Compact & Repair - Access - Resolved
I have a series of Access db's that aren't explicitly opened, but have another db that imports tables from them.
1. Will the ones whose tables are imported run compact & repair on close (assuming that's set in their options) when the import is done?
2. If so, will the c & r run after each table import (there might be 20 tables imported, which would be too much time overhead).
3. Or can I call c & r on them programatically?
Most of the dbs are only accessed once a month, and we had one get a couple corrupted tables, and it was a real pain to try to repair.
Thanks.
Reply With Quote