View Single Post
  #1 (permalink)  
Old February 18th, 2006, 11:31 PM
Scripts82 Scripts82 is offline
Authorized User
Join Date: Feb 2006
Location: , , Singapore.
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Reply With Quote