Record Locking

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
 
R

Risse

"alex" <[email protected]> kirjoitti
viestissä:[email protected]...
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
 
M

Marco Pagliero

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).
Setting db opens = shared mode and default record locking = Edited
records has always worked for me. I never set it in any form.
Hope it helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top