Record-level locking can not use in DAO ?

S

S.L.

I have read from somewhere that Jet 4.0 support record-level locking and ADO
have function to do that.

But with DAO (even DAO 3.6),No this kind of function is built in object
model.

Is it true ? Because, I testing Access XP and using DAO. It can not lock a
single record. It do page-level locking.

TIA
 
L

Lance

Yes, record level locking is available. Unfortunately, if
you have memo fields though Jet still does use page level
locking.
 

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

Similar Threads

DAO 3.6 and Record level locking 2
lock multiple records 0
Record level locking 0
Record Locking 6
Best way to deal with record-locking conflicts 3
swtich DAO to ADO, how to get a record into Excel 2
DAO IS DED 18
Pessimistic Record Locking 0

Top