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, ...

Get 2007 Microsoft® Office System Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.