Database synchronism problem

[Guest]

I have a database on the LAN. The problem is when any user open it other
users can not open it. What should I do to make all users use it without any
interruption?
Thx.

 

[Joseph Meehan]

I have a database on the LAN. The problem is when any user open it
other users can not open it. What should I do to make all users use
it without any interruption?
Thx.

There are a number of possible issues. What kind of error message is
generated? A common problem is one user opening the database in "Exclusive"
mode which of course means them exclusively.

 

[Guest]

As Joseph indicates, if a user opens a database in exclusive mode, this will
prevent other users from opening the database. Check each user's PC to ensure
that none of your users have this option set. Open Access on each of their
machines, and then click on Tools > Options... | Select the Advanced tab. The
"Default open mode" should be shared. I recommend setting the "Default record
locking" option to No locks, and place a check in the option that reads "Open
databases using record-level locking".

Another common reason is that at least one user does not have full
permissions to a shared folder. If this user's privileges do not allow the
creation of a locking database file (*.ldb), then they won't be allowed in,
*unless* they are the first one to open the database, in which case others
will not be allowed in. More information here:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

Finally, here an article that covers other considerations to be aware of:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________