Split an existing Access database between its data and its objects
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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.
On the Tools menu, point to Database Utilities, and then click Database Splitter.
Follow the instructions in the Database Splitter Wizard dialog boxes.