Slow after compact?

[mmusick]

We have an mdb w/ internal data, running remotely. Before and after compact - a query of records used to take 4 seconds is now approaching 40. The sql is selected from an ini file based on 4 passed parameters and the output is a csv file feeding another application. I am not familiar with the use of custom dll's and ini files, but neither has changed. Not sure what to look at!?

 

[markgrizzle]

Try decompiling/recompiling the app before repair/compact.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /decompile "App.mdb"

Once you've opened it this way, go to the code module and compile it. Then go to the database window and repair/compact.

Hope this helps.