Split an existing Access database between its data and its objects

This procedure splits 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.

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.