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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a small office with several employees who need to enter data into the
same Access DB simultaneously. Is this possible?
 
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

Question about form operations 5
enter paramerter value 4
Pasting email address into text field 1
opening only one form at a time 1
Access 2007 this database has been opened read only 0
simple address db - how would you do this? 3
Data Entry Form 3
Access 2003 Question 2

Back
Top