help with record locking

[Bob Parr]

I have a database that is being shared by several users. I want to lock a
row in a table when it is being edited. I have the "open databases with
record-level locking" option set, but when I test, opening the recordset
with:

Set currentrec = db.OpenRecordset(qstr, dbOpenDynaset, dbDenyWrite)
currentrec.LockEdits = True
or
Set currentrec = db.OpenRecordset(qstr, dbOpenDynaset, dbDenyWrite,
dbPessimistic)

the whole table is locked. I get an error 3262

Any ideas what I am doing wrong?

Bob

 

[Bob Parr]

I have a database that is being shared by several users. I want to lock a
row in a table when it is being edited. I have the "open databases with
record-level locking" option set, but when I test, opening the recordset
with:

Set currentrec = db.OpenRecordset(qstr, dbOpenDynaset, dbDenyWrite)
currentrec.LockEdits = True
or
Set currentrec = db.OpenRecordset(qstr, dbOpenDynaset, dbDenyWrite,
dbPessimistic)

the whole table is locked. I get an error 3262

Any ideas what I am doing wrong?

Bob

 

[TC]

I assume you have A2k+? (A97- do not have record-level locking.)

Surely dbDenyWrite is a recordset-level attribute? Would that not deny other
processes writing to any record shown in that recordset?

What are you actully trying to achieve?

HTH,
TC
(off for the day)

 

[Bob Parr]

PLEASE HELP ME

 

[OzPete]

Bob,

You might want to wait until all parts of the world wake up, in their own
particular time zones...

patience dear boy...

Pete

 

[Bob Parr]

The request has been up for almost a week. I am trying to be patient.

Bob