A
alex
Record Locking
Hello,
Using Access 03…
I’ve been researching access record locking for about two days now and
I can’t seem to find any solid advice.
I have a typical database (fe mde with linked access tables to be mdb)—
users have their own fe. The db opens in shared mode, the default
record locking is No Locks, and the ‘Open database using record-level
locking’ is checked. With most of my forms, users will never access
another’s record. But I have this one…
It’s my understanding that you actually set the record locks via a
form, which I did on a single form (I set Record Locks to Edited
Records…Recordset Type is Dynaset). I did some testing with another
user (she opened/modified a record on her pc and I opened the same
record on my pc).
Instead of the record (on my pc) being locked, I was allowed to change
it (or begin to change it) and then I receive a run-time error on some
code in the form’s on dirty event. Shouldn’t the record just be
locked?
I’d listen to any advice on this topic.
Thanks,
alex
Hello,
Using Access 03…
I’ve been researching access record locking for about two days now and
I can’t seem to find any solid advice.
I have a typical database (fe mde with linked access tables to be mdb)—
users have their own fe. The db opens in shared mode, the default
record locking is No Locks, and the ‘Open database using record-level
locking’ is checked. With most of my forms, users will never access
another’s record. But I have this one…
It’s my understanding that you actually set the record locks via a
form, which I did on a single form (I set Record Locks to Edited
Records…Recordset Type is Dynaset). I did some testing with another
user (she opened/modified a record on her pc and I opened the same
record on my pc).
Instead of the record (on my pc) being locked, I was allowed to change
it (or begin to change it) and then I receive a run-time error on some
code in the form’s on dirty event. Shouldn’t the record just be
locked?
I’d listen to any advice on this topic.
Thanks,
alex