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

Chapter 4. Navigating the Access User Interface > Using the Database Utilities

Using the Database Utilities

Access 2000 offers the following seven utility functions, which you access by choosing Tools, Database Utilities:

  • Convert Database lets you change the version of the currently open database to the Access 97, 2000, or 2002 version by saving it as a new .mdb file. The choice corresponding to the current database version is disabled.

  • Compact and Repair Database checks the database for consistency, repairs problems found, and then compacts it to save disk space. You can compact the database to a new file or overwrite the existing file with the compacted version.

  • Linked Table Manager tests for the existence of linked .mdb or other types of data files and, if the links aren't valid, lets you change the path to the linked files. This choice is disabled if you don't have a database open.

  • Database Splitter divides a single-file Access .mdb application with application and data objects into a front-end .mdb file and a back-end Jet database. This choice is disabled if you don't have a database open.

  • Switchboard Manager creates a new Switchboard form if one isn't present in the current database and lets you edit the new or an existing Switchboard form. This choice is also disabled if you don't have a database open.

  • Upsizing Wizard lets you move tables and queries from the current Jet database to SQL Server and, optionally, change the .mdb file containing application objects to an Access Data Project (.adp) file.

  • Make MDE File creates a secure copy of the file, which prevents users from opening objects in Design view and viewing or changing VBA code. This choice is enabled only when no database is open.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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