Show All

Hide All

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

You can split a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) into two files: one that contains the tables and one that contains the queries, forms, reports, macros, modules, and shortcuts to data access pages (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.). This way, users who need to access the data can customize their own forms, reports, pages, and other objects while maintaining a single source of data on the network.

1. On the Tools menu, point to Database Utilities, and then click Database Splitter.
2. Follow the instructions in the Database Splitter Wizard dialog boxes.