2007 Microsoft® Office System Step by Step, Second Edition

Preventing Database Problems

In the day-to-day use of an Access database—adding and deleting records, modifying forms and reports, and so on—various problems can develop. This is especially true if the database is stored on a network share, rather than on a local drive, and is accessed by multiple users. Access monitors the condition of database files as you open and work with them. If a problem develops, Access attempts to fix it. If Access can’t fix the problem, it usually provides additional information that might help you to find a solution. But Access doesn’t always spot problems before they affect the database; if this happens, you might notice that the database performance seems to slow down or become erratic. Even if no actual errors occur, ...