Allowing multiple users access to database

B

Bill Trainer

I have a database that is being shared by multiple users from one department
without any problems. The database sits on a shared server along with 3
different front ends that provide user specific access. There are no issues
at this time within the primary department.

The database needs to be shared with another department that has a different
shared server. I mapped each user to my departments shared server with
Read/Write access. Reset the links to point to our _be.mdb file and tested
each workstation. Each of the users from the other department can access the
database, however only one can do so at a time.

When someone in the other department opens the database and someone else
attempts to open it also the second person will get a message that the
database is opened exclusively by another user. The "Default open mode"
setting is set to shared.

What needs to be done to allow multiple users in the other department have
access at the same time?

In advance thank you for your help or ideas.
 

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

Top