How can more than one user enter data into an open Access DB?

B

Bruce Smith

We have a small office with several employees who need to enter data into the
same Access DB simultaneously. Is this possible?
 
J

JackP

yes. access is designed to be multi-user.

However, in order to get the best use out of it, you should have the users
access the data via forms and reports rather than directly in the tables.

Also, in order to reduce corruption risks, once you're ready to deploy the
database, split the database into a front-end / back-end system (basically
only the data and relationships sit in the back end - everything else is in
the front).

In access 2000 you can do this through tools/database utilities/database
splitter
 
Top