access2000-compact on close
i have 15 front ends that connects to the sql server. the data will be kept locally before it uploaded automatically every 2minutes to the server.every front ends is differ from each other. i want to set each mdb to compact on close and will have my users to open and close the database every one week.
1. when it close will it create a compacted database and delete the
old database automatically?
2. will it automatically change the name of the compacted database to
the previous name?
really need an advice...thanks alot.