O'Reilly logo

Alison Balter's Mastering Access 97 Development, Second Edition by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required