Access 2016: Split a Database
Splitting a database involves separating the data from the rest of the database, and can help with performance when multiple users share the database over a network.
It's a good idea to split any database that needs to be shared by multiple users over a network. This can help with performance, and it can reduce the chance of the database file becoming corrupt due to multiple users accessing it at the same time.
Splitting a database involves separating the database into two files. One file is the back-end database that contains all the tables and data. The other file is the front-end database that contains all other objects, such as queries, reports, and forms.
Users work with a local copy of the front-end database, and the data is sent/retrieved from the back-end database. So, there could be many copies of the front-end database, but only one copy of the back-end.
By doing this, only the data needs to be sent across the network. With a non-split database, all database objects need to be sent across the network, which typically results in a slower experience for the user.
Also, users can create their own queries, forms, reports, macros, etc without impacting on the other users.
Split the Database
We'll now split the Music database that we've created throughout this tutorial.
Be sure to back up your database before you split it. Doing this will enable you to restore the database to its pre-split state in case you need to do so for whatever reason.
Check the Front-End Database
You can verify that the split took place by opening both database files.
First, let's open the original database. It uses the original database file. In our case, this is the Music.accdb file.
Check the Back-End Database
This is the database that holds the data. It uses the new database file that we created (Music_be.accdb).
Now, if you've decided that you do in fact need to split your database into front-end and back-end, you will probably also want to do one more thing — turn the front-end into an executable file.