• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Navigating Within Acces > Using the Database Utilities

Using the Database Utilities

Access 97 offers four utility functions, which you access from the Tools, Database Utilities menu. You can perform three of these functions (Compact a Database, Repair a Database, and Make an MDE File) with or without a database open; the fourth utility function (Convert a Database) can be performed only when no database is open. If you have a large database, these operations take a considerable amount of time. If you select one of the utility operations described in the following sections when you do not already have a database open, the operation involves two dialogs. In the first dialog, you select the database in which Access is to perform the operation; in the second dialog, you enter the name of the file that the operation is to create. Default file names for new files are Db#.mdb, where # is a sequential number, beginning with 1, assigned by Access. For the three utility operations you can perform with an open database, only the Make MDE File option displays a dialog. When compacting or repairing an open database, Access assumes that you want to operate on the open database and want the resulting compacted or repaired database to replace the currently open database.

Compacting Databases

After you make numerous additions and changes to objects within a database file—especially additions and deletions of data in tables—the database file can become disorganized. When you delete a record, you don't automatically regain the space in the file that the deleted data occupied. You must compact the database to optimize its file size and the organization of data within the tables that the file contains. When you pack an Access file, you regain space only in 32K increments.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint