J Joe K. Mar 6, 2008 #1 I am looking for a script that I can use to compact the Access database before the database is backup. Thanks,
I am looking for a script that I can use to compact the Access database before the database is backup. Thanks,
D Daniel Pineault Mar 6, 2008 #2 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.
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.
