p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Compacting the Frontend (http://p2p.wrox.com/showthread.php?t=38676)

Scripts82 February 18th, 2006 11:31 PM

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.
Thanks!!!

Scripts82


All times are GMT -4. The time now is 08:57 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.