simultaneous user issue

[Guest]

I get the message "cannot lock table..." when user B tries to open the
already opened MDB. all persmissions are given to the folder and DB.
everything is set to share and the database has been split.

im guessing i have told the db to lock upon opening, but i can find anywhere
to prevent this...?

 

[Joseph Meehan]

I get the message "cannot lock table..." when user B tries to open the
already opened MDB. all persmissions are given to the folder and DB.
everything is set to share and the database has been split.

im guessing i have told the db to lock upon opening, but i can find
anywhere to prevent this...?

A may be opening it exclusively. That is not the default, but it sure
happens.

You say it has been split, but do both A & B have their own copy of the
front end on their own machine?

 

[Guest]

In add to Joseph's comments, it is *very* important that each user have their
own copy of the front-end (FE) application. Are you doing anything in startup
code that might be locking a table? If you rename an Autoexec macro (if
present) and set the startup form to [None] (Tools > Startup), do you still
experience this error?

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
__________________________________________