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

Chapter 12. Managing a Database > Splitting a Database

Splitting a Database

You can reduce the size of a database file by splitting the database. When Access splits a database, it places the tables in one file, called the back-end database, and the other database objects, like forms and reports, in the current database file. This technique stores all of the data in one location, while allowing each user to create his or her own forms and reports in his or her own database files.

Split a Database

Make sure all users close the database, and then close the switchboard, if necessary.

Open the database with administrative privileges.

Click the Tools menu, point to Database Utilities, and then click Database Splitter.

Click Split Database.

Enter the name and location of the back-end database that contains the database tables.

Click Split.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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