one of the easy way to compact/repair the database
set the database to compact on close tools->options
Know in the backend data base create a macro call autoexec
and get it to quick
now build a scheduled task to open the backend database
autoexec get run it quicks then it compacts done
also it keep out people out of the database if they try to open it.
have the database in a place where it is part of the company daliy backups
Last edited by myle; 01-13-06 at 14:59.
hope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON