S
S.L.
With following code :
Set wkDB = CurrentDb
Set wkRS = wkDB.OpenRecordset("select * from MTR1 where MTR1_CD = 'A' ",
dbOpenDynaset, dbDenyWrite)
I can open MTR1 table thru database window. Yes, I can not modify or add new
record. It locked BUT not only record that MTR1_CD = 'A'. I don't know it
lock one data page or lock the table.
Question are :
1) What does above code lock ? One data page or a whole table.
2) By programming, Can I lock only one record at a time ? How to do that ?
3) When I change from dbDenyWrite to dbDenyRead. It make me more confuse. I
can open and modify any record in MTR1. Why ? I should unable to open MTR1
table, shouldn't I ???
TIA
Set wkDB = CurrentDb
Set wkRS = wkDB.OpenRecordset("select * from MTR1 where MTR1_CD = 'A' ",
dbOpenDynaset, dbDenyWrite)
I can open MTR1 table thru database window. Yes, I can not modify or add new
record. It locked BUT not only record that MTR1_CD = 'A'. I don't know it
lock one data page or lock the table.
Question are :
1) What does above code lock ? One data page or a whole table.
2) By programming, Can I lock only one record at a time ? How to do that ?
3) When I change from dbDenyWrite to dbDenyRead. It make me more confuse. I
can open and modify any record in MTR1. Why ? I should unable to open MTR1
table, shouldn't I ???
TIA