Compacting the Frontend
Hi, currently i have a databased deployed using ms access (mdb) file.
The front end (mde file), residing inside each individual's computer contains the forms and etc to access the data in the backend.
My problem is as follows:
==> Everytime the user open/close the front end mde file, I want to run a routine/macro (in the front end mde) to compact the front end file. How do I do it?
I know I can use: dbengine.compactdatabase
But the problem is where do I invoke it?
I cannot invoke it while the file is opened as the compact needs the current mde file to be closed...
I know that I can also use the "\compact" in the command line. How to do this using vba?
Any help is greatly appreciated.