MS Access - How to split your database and allow multiple users to enter data at the same time
This tutorial will show you how to split your Microsoft Access database so multiple users can enter data at the same time.
By splitting the database, you can create multiple files, also called front end databases, that will all act as a tunnels to your one central data storage location, also called a backend database.
Creating a front end database will also allow you to accommodate preferences for different users. Some users may want certain reports, queries, and forms that are specific to them, whereas others may not.
