Database Locked by an Admin User

[Guest]

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

 

[Joseph Meehan]

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

It is hard to prevent it from happening. It is often caused when
someone just turns their computer off without shutting down applications
first.

Here are some links, previously posted by someone else, sorry I don't
remember who.


http://www.datastrat.com/Download2.html
Look for KickEmOff2K sample database.

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOff2k.mdb'

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOffNonUse2k.mdb'

http://support.microsoft.com/?id=198755

http://support.microsoft.com/?id=285822

http://www.candace-tripp.com/_pages/access_downloads.asp
Look for Detect and Logoff Idle Users

http://propertychampion.com/Developer_Tools/Addins/Addins.html
Look for "Force User Out"

 

[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.

 

[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

 

[Guest]

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.

 

[Guest]

Yes, I have two databases for front-end and back-end.