How to Split MS Access Database for Multiple Users
- George Apostolov
How to Split MS Access Database for Multiple Users: step-by-step guide
Open the database you want to split.
Go to the 'Database Tools' tab in the 'Ribbon'.
Click 'Access Database' under the 'Move Data' group.
You will be able to open the 'Database Splitter Wizard'. Click 'Split Database'.
The wizard will create a file with the same name as your database but with "_be" appended.
Click 'Split' to confirm the action.
Once the process is complete, your database is split. Click 'OK'.
Quick answer: To split MS Access Database for Multiple Users, open the database, navigate to the Database Tools tab in the Ribbon, and click Access Database under the Move Data group. Open the Database Splitter Wizard, click Split Database, allow the wizard to create the backend file, click Split to confirm, and click OK when finished.
About this tutorial
Divide your database for multiple users in the app by using the Database Splitter Wizard under the Database Tools tab. This guide shows how to split MS Access Database for Multiple Users in 7 steps, starting with "Open the database you want to split" and finishing with "Once the process is complete, your database is split. Click 'OK'". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to split MS Access Database for Multiple Users?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
