Locks

#1 (**permalink**) 28-Jul-2006, 08:15 AM

I have been charged by my boss to research the Access Edit locks (no lock,
Edited Lock, All Records) and to discover which the best to use in our
environment is. So far I have found them to do nothing, generating the same
messages and error under the same Circumstances.

Admittedly I haven't tried everything yet, and I plan to do more testing,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10666-locks.html
but I have discovered that this property stays relative no to the database
but to the computer/access that it is running on. I was thinking to myself
that there might be a piece of code that could be used to adjust this, or
else it would be quite the task to set every computer to have the same access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10666
level.

#2 (**permalink**) 28-Jul-2006, 08:15 AM

It would help if we had a better idea of what you were trying to do,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10666
meaning why are you trying this? to what purpose?

You may be looking down the wrong path.

#3 (**permalink**) 28-Jul-2006, 08:15 AM

You may want to look at the following thread. The explanations there
may answer a lot of your questions:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10666

http://groups.google.com/group/micro...43e013/?hl=en#