How to Split MS Access Database for Multiple Users

Quick summary

The MS Access Database Splitter separates your database into a back-end file (tables) and a front-end file (queries, forms, reports), enabling multiple users to access shared data simultaneously without conflicts.

Steps

1. Open the database you want to split in Microsoft Access.
2. Navigate to the Database Tools tab in the Ribbon.
3. Click Access Database under the Move Data group.
4. In the Database Splitter Wizard dialog, click Split Database to begin the process.
5. The wizard will generate a back-end file using the same name as your database with "_be" appended — confirm the file location if needed.
6. Click Split to confirm and execute the database split.
7. Once the process completes, click OK to finish — your database is now successfully split for multi-user access.