Opportunistic locking?

[Brian Cheresnowsky]

I have several databases that I share among 20-40 users
at one time. I periodically will get the following
messages when certain conditions are present:

"Database has been placed in a state that prevents is
from being opened y <user> on machine <x>."

"Unrecognized database format \\drive\database.mdb"

"Could not update, currently locked by <user> on machine
<pc location>."

Some of my peers have helped me look at this, and we
think it is opportunistic locking, however, our desktop
support group seems to think that I am crazy. They tell
me that opportunistic locking doesn't exist, because it
should be resolved in any windows update, and also that
they don't support problems with MS Access.

Can anyone help shed some light on this? This is the
first time I have experienced these issues.

Thanks!

Brian

 

[Stephen Lebans]

You're definately not crazy!<grin>
This issue has been well documented over the last several years.
Searches on the MS KB and on GoogleGroups will yield the relevant
information.

For starters, read Tony's article on this issue here:
http://www.granite.ab.ca/access/corruption/causesoplocks.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Tony Toews]

I have several databases that I share among 20-40 users
at one time. I periodically will get the following
messages when certain conditions are present:

"Database has been placed in a state that prevents is
from being opened y <user> on machine <x>."

"Unrecognized database format \\drive\database.mdb"

"Could not update, currently locked by <user> on machine
<pc location>."

Some of my peers have helped me look at this, and we
think it is opportunistic locking, however, our desktop
support group seems to think that I am crazy. They tell
me that opportunistic locking doesn't exist, because it
should be resolved in any windows update,

<shrug> Supposedly the latest updates solve the OpLocks problem. But
these updates have to on both the server and the clients.

But there may be other problems. For example Opportunistic Locking
May Not Be Granted If Windows Is Installed by Using Sysprep
http://support.microsoft.com/default.aspx?scid=kb;en-us;812599&Product=WinXP.

How often do these problems happen? If it happens several times per
day or even per week then the OpLocks is more likely. If less often
then I'd look elsewhere.

Regardless what does it take for the sys admins to test this problem?
Set the registry key and reboot.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

and also that
they don't support problems with MS Access.

Idiots.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm