Hello,
I am calling MS Access from a VBA script in MS Excel, executing some queries, then closing Access. The database is set up to compact on close, which is what I want it to do. My question is this, in my VBA script I then open another database. Do I need to insert some code to allow the first database to compact before opening the second? More specifically, I find situation where I would like to be sure that the script waited until the compact process was complete before proceeding with the VBA script. Any insights would be appreciated.
Thank you.
