Database Locked by an Admin User

N

Nyla K

Hello,

I'm developing a shared database that will be used in the organization via
LAN and WAN. My biggest concern is that Access will sometimes randomly get
locked by a user or workstation. The weird thing is that the user, based on
the IP address given on the error msg, does not have the database open. The
only way to unlock the database is to have everyone log out of it and log
back in. The unfortunate thing is that the person that's locking the system
may be at lunch or at a meeting, which then prevents anyone else from being
able to log into the database.

Any suggestions on how I can prevent this from happening?

Thanks,
Nyla
 
L

Lynn Trapp

Nyla,
The problem is, most likely, being caused by a user improperly shutting down
Access. Using the Windows task manager to shut Access down can often leave a
"ghost" user in the .ldb file. I don't know of a way to completely prevent
that, but some good training of your users will help.
 
S

SirPoonga

Is this a Front End/Back End situation or is everyone running the same
database file?

If you aren't using a front end and back end I suggest doing that.

you can find more info in microsoft.public.access.multiuser
 
M

Micah Chaney

Try splitting the Database. Or what I did make each page (form) the user
sees a pop up, this will get rid of that big red X in the upper right corner.
However if a user goes to the Task Manager and shuts down Access that way,
you can still have the same problem. Seems to be a training issue, though.
Hope this helps.
 
Top