run multiple instances of the same database

[chriswrcg]

how do I set it up so that multiple people can do data entry on the same database at once? Right now the database is in a file on our company's share drive. It is on the network so multiple people can look at it. How can i make it so that two people (or more) can work with the database at the same time doing data entry and how to I "merge" the two back into one when they are done?

[Minty]

You will need to split your database into separate front end (FE) and back end (BE) files.

The FE)will contain all the forms reports and queries, the back end simply the tables (Data).
You link the BE tables into the front end database , and every user gets a local copy of the FE on their machine. The BE remains on the network share.

Lot more on how and why to do this here http://www.fmsinc.com/microsoftaccess/databasesplitter/

And a search on here as well will provide further assistance.