How to Split and Separate Your Database in Access 2010


show more Splitting a database provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Splitting a database

If you have many users of your database, consider converting to a Split Database Architecture. Your database can be divided into a front-end database that contains all the application objects, queries, forms, reports, macros and models, and is linked to tables stored in the Back-end Share Database containing the data. The back-end database can be stored in the location shared by many users, such as a File Server. The front-end database is distributed to each user's desktop and linked to the shared database. Using this design, each user has a copy of Microsoft Access installed on their machine along with their Application database.

This reduces network traffic, because the application is not retrieved for each use, and it allows the front-end database to contain tables with data that are private to each user for storing settings or temporary data. The Split database design also allows development of the application independent of the data. When a new version is ready, the front- end dat...

Splitting a database
Video duration: 2m 27s 3h 30m Beginner

Viewers:

Splitting a database provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...