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

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enter paramerter value 4
Question about form operations 5
Data Entry Form 3
simple address db - how would you do this? 3
Update multiple records based on multiple fields? 1
Cannot edit Access 2007 DB via Form- get "DB opened in Read Only M 1
Modifying a DB from multiple systems at the same time? 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top