I have an excel file which, via power query, imports thousands of rows of data from an access database. The sheet has multiple users but is password protected meaning only I, have write access.
I am relatively new to Access so forgive me for the basic questions:
1. Having only created the sheet recently, I am constantly having to "compact and repair" the database - does that sound right or could there be something wrong with the database?
2. I have amended the settings of the database so that on close, the compact and repair function is run. With that in mind is it possible to:
i) Write some code (in the excel file) to open and close the database (and therefore I assume the compact and repair function will be run)
ii) If the above is not possible then, write the code to open the database, run the repair, then close?
From my research I have written the following:
Can someone verify whether this looks correct and what I need to add, for the code to run the compact and repair function?
Please Login or Register to view this content.
Any help would be great.