Default Record Locking

[Guest]

I hav a database split into front ends onthe users' workstations, and a back
end on a server. I have the Default Record Locking on the back end set to
"Edited Record" (Tool/Options/Advanced). As I understand it, this locks a
record as soon as it is accessed by anyone.

Does it make any difference what this setting is on the front ends? I have
them set to "Edited Records" too, but I was just wondering. Thanks!

 

[Mike Labosh]

I hav a database split into front ends onthe users' workstations, and a

back
end on a server. I have the Default Record Locking on the back end set to
"Edited Record" (Tool/Options/Advanced). As I understand it, this locks a
record as soon as it is accessed by anyone.

Does it make any difference what this setting is on the front ends? I have
them set to "Edited Records" too, but I was just wondering. Thanks!

The setting on the front-end is what counts. The setting on the backend is
meaningless.

Remember that this setting does not affect your MDB files in any way. It
affects the way that MSACCESS.EXE performs locking when accessing the stuff
in your MDB files. Microsoft Access in itself is also a "client"
application that talks to the database (mdb file)

So if I have a file server and some user computers, and I install Microsoft
Access on each of them, and then I put my mdb file on the file server...

1. No one is actually running Access *on* the file server, so since it's
Access that does the locking as it talks to the mdb, there is no "locking
behavior to speak of.

2. When your user(s) sit at their client workstations and launch your mdb
with Access, each user's instance of Access performs the type of locking
that it - itself - is configured for.


--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.

 

[Albert D.Kallal]

You have a good answer from Mikes post.

I will also add hat just changing the setting in tools option actually sets
the "default" for NEW forms that you create.

If you did not set this correctly, then you have to do go to each form, and
set the setting (it is in the data tab).

Of couse the setting does apply when you are editing tables direclity...but
no one does that!!

 

[aaron.kempf]

access is not a client in the typical client-server role

MDB is 1st-generation shit; true client server is 2nd generation.

MDB is dead; don't use it ever anywhere.

use SQL Server and Access Data Projects