Access and multi-users

M

Melanie

Our access database is currently set where if one user is
in it, no one else is allowed. How can this be changed?
 
C

Chris Sergent

You might want to make sure that your user are not opening
the database exclusively. To set the default to shared, do
the following:
1. Open the database
2. Click Tools
3. Click Option

A dialog box will open.

4. Click the advance tab and ensure that the Default Open
Mode is set to shared.

5. Click OK.

Note: You can still open the database exclusively but it
takes an extra step. When opening the database. Ensure
your user have a shortcut icon on their desktop that goes
directly to the database and they won't be given this
option when opening.

Hope this helps.
 
L

Larry Linson

Our access database is currently
set where if one user is in it, no
one else is allowed. How can this
be changed?
Click to expand...

Sounds as if you've opened for exclusive use. In Access 97 and 2002, this
can be set as a default for opening databases. I don't have Access 2000 on
this machine, but assume it has the same setting.

To reset it, on the menu, Tools | Options choose the Advanced tab and click
the Radio Button for Shared under Default Open Mode on each users machine.

Larry Linson
Microsoft Access MVP
 

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

Crating User Form to Add Names 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Space at end of multi page list to accommodate new entries 1
Changing login email address for office 365 admin (O365 Busines) 0
Incorporating the User Profile location into a document template path 1
Template location changes from user to user 0
Microsoft 365 Activations, Users or Devices? 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0

Top