Get message: "Locked by user Admin" Why?

[Pelle55]

Hi!
When one user have started up my Access database, it works ok but when the next user starts up and tries to put in new posts i the db she gets this message:

"You can`t update. Locked by user "Admin" on MMN 6894R"

What is the problem??

 

[Garridon]

If it's on a network, check the network permissions for the users. I had a terrible time with this because I'd missed a single permission. And I did get exactly that error. Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[jryan224]

Pelle55,
Check to see how the user is opening the db. In access, open/file the "Exclusive" box may be checked. If this is checked, only one user can use the db at a time.

There is an option to set this as either shared or exclusive.

In access 97, in Tools|Options there is an "Advanced" tab where you can set the "defalut open mode" to either shared or exclusive. Check to make sure this is set to shared.

You would only open as exclusive as administrator if you were doing maintenance and wanted to lock out the users.

Jdemmer
God Bless

 

[Garridon]

Oops--I should have added that the permissions were on the folder the database was in on a network shared druve.

Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com