Record Locking Problem

[Guest]

I have been experiencing problems with record locking. Most people seem to
struggle with unwanted locks but my problem is that I cannot seem to get
record locking to work. I first spotted the problem on an application that
was causing problems due to users changing the same records. Whatever I do I
cannot get the records to lock and I am experiencing the same problem on a
small test db designed to investigate the problem.

I have set the database options as follows (which is my preferred option):

Open Database use record-level locking - true
Deafult open mode = shared
Default Record Locking = edited

I have also checked that the forms and queries have the record locking
option set to "edited record"

This SHOULD allow me to view the same record with two different forms but
not let me make changes - but I can change the records!!!

I have tried playing around with the options but all setups and tried it
with a standalone and a split database but it still allows me to change
records.

I am using Access 2003.

Am I missing an obvious trick?

Regards

Ken

 

[[MVP] S.Clark]

Open two instances of Access, and open the form in both.

Edit record in F1. Now try to edit the record in F2?
if Allowed in F2, then save F2. Now try to save F1. What happens?

If some warning or alert hasn't triggered by now, then something is really
wrong.

 

[Guest]

I think something is really wrong!! My test database is a simple single
table, single form that I have split and loaded onto different machines. I
can open the form on both machines and go to the same record. I can then edit
and save the record in either form without any error messages.

Any suggestions??

 

[German Saer]

You are not opening to different Dbs, are you?

Make sure you open the same DB from both machines. That shouldn't happen at
all.


--
___________
Thanks,

German Saer
Orlando, FL

 

[Guest]

No. I am opening the same backend database and can see the the changes that
the different machines are making!!