Split an Access database (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
You can split a Microsoft Access database into two files: one that contains the tables and one that contains the queries, forms, reports, macros, modules, and shortcuts to data access pages. 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.
- On the Tools menu, point to Database Utilities, and then click Database Splitter.
- Follow the instructions in the Database Splitter Wizard dialog boxes.