O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

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

12.5. Maintaining the Application

Just because you have deployed your application to end users does not mean that your job is finished. It is important that you periodically compact the database to keep it in good working order and that you make periodic backup copies.

12.5.1. Compacting and Repairing the Database

You can compact and repair Access databases to reduce the amount of space they take up and to repair problems if Access discovers any. Because Access databases are file-based, records are being deleted and added to the system over time. A large amount of space may have been taken up by an operation that has already been completed or by database records that were already deleted. Compacting the database will recover that space and reduce the file size.

To compact and repair an Access database, select the Office Button Manage Compact and Repair Database. If you have the database open that you want to compact, selecting this option will automatically compact that one. If no databases are open, you will be prompted to specify the name and location of the database to compact.

12.5.2. Making Backup Copies of the Database

If you are like most people, you have probably lost data from some program before. It was certainly frustrating to lose the data and have to recreate it again. ...

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