How do I allow multiple users to view and enter in one database?

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

Guest

I created a database for multiple users to access to view and enter
information into, however, only one user can access at a time. How do I set
up the database for mulitple user access?
 
By default, it should be multi-user friendly. Do the users have full
windows permissions to the file in which the database lives? They must be
able to read, write, modify, and delete from that folder.

If you go to TOOL/OPTION, and select the ADVANCED tab, what is the DEFAULT
OPEN MODE? IS it shared?
 
Niffer67 said:
I created a database for multiple users to access to view and enter
information into, however, only one user can access at a time. How do
I set up the database for mulitple user access?

My nature Access allows it. Assuming you have a good hard-wired network
you should be able to have 20 or more users at one time.

If only one user can actually use it they may be opening it up
"exclusively" You will need to have that changed. You may also want to take
a look at where the file is located and see if you see a file named
YOURFILENAME.LDB when no one has the file open. If one is there, try
deleting it. If you are unable to delete it, your problem is likely a
rights to that directory problem. Each user needs full rights to that
directory including delete. If you can delete it you may have fixed it
because it may have been corrupted.
 

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

Back
Top