I was hoping to link a simple button on a form to a macro that will compact and repair my split database:
I have the Forms and Queries at this location: M:\Science\
Front End Filename:PendingLog_v1.accdb
Backend Here: M:\Science\Backend
Backend Filename: PendingLog_v1.accdc
Is there a simple Macro I can link to my form that will accomplish this? I was looking online and found a few different answers. I wasn't sure if these applied to split databases though.... I was just wondering what the best way to go about this would be?
I appreciate you taking the time to view my inquiry.
Will this work or do I need something more robust?
Code:
Application.SetOption "Auto compact", True