Compact Access Database

[Joe K.]

I am looking for a script that I can use to compact the Access database
before the database is backup.

Thanks,

 

[Daniel Pineault]

You could simply perform a shell command using access' command line switches.
Thus a bat file, vbscript or vba automation could all potentially work.

Here are two go sources of information on command line switched for access

http://support.microsoft.com/kb/209207
http://www.vb123.com/workbench/help/commandline.htm
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.