Splitting a Microsoft Access database is the process of dividing your database into two files: one that contains the tables, known as the Back-end database and one that contains the queries, forms, reports, macros and modules, known as the Front-end database. The Front-end database contains links to the tables in the Back-end database. Often, each user will have their own copy of the Front-end database on their desktop, allowing them to customize their database objects while maintaining a single source of data on a shared network drive.
Splitting a database is also a good idea if you create and maintain a database for others. Should they desire a change such as additional forms or reports, their database need not be taken offline. You would make the changes to the Front-end database and, when completed, simply replace their Front End database with the one that incorporates their changes. The data in the Back-end database is never touched.
To Split an Access Database
- Click the Database Tools tab on the Ribbon.
- Click Access Database on the Move group on the Ribbon.
- Click the Split Database button.
- Navigate to the location where you wish to store your Back-End database.
- In the File name box, type the desired file name for the Back-End database.
- Click the Split button.
- Click OK when the message box appears informing you that the database has been successfully split.
Similar Posts:
- None Found
Comments on this entry are closed.