Configure access database to be a back end and front end

[walejo89]

how you configure the access database to a standard front end and back end configuration.

 

[Lightning]

Split an Access database
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.

HTH
Lightning