|
It is not uncommon for Access databases to become corrupt. We have noted this problem particularly when accessing a database across a network. Try and keep the database that you are working with on the same computer as the Access program itself. We use the Tools>Database Utilities>Compact and Repair Database option from time to time. This seems to minimize the problem of a corrupt database.
From the help file: Repairing an Access database In most cases, Microsoft Access detects that an Access database is damaged when you try to open it and gives you the option to compact it at that time. In some situations, Microsoft Access may not detect that an Access database is damaged. If an Access database behaves unpredictably, compact it. Compacting a previous-version Access database won't convert it to Access 2000 format. Learn more about converting a previous-version Access database. If you are compacting a multiuser (shared) database that is located on a server or shared folder, make sure that no one else has it open. You must have Open/Run and Open Exclusive permissions for an Access database in order to compact it.
|
