Chapter 35. Database Maintenance Techniques
Understanding What Database Maintenance Is All About
Although you don't need to do too much to maintain an Access database, you must know a couple of important techniques in order to ensure that your databases are maintained as effectively as possible. The two techniques you should be familiar with are compacting and repairing. Compacting a database means removing unused space, and repairing a database involves repairing a damaged database (MDB) file. Both these processes and the ways you can accomplish them are covered in this chapter.
Compacting Your Database
As you and the users of your application work ...
Get Alison Balter's Mastering Access 97 Development, Second Edition 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.
