MS Access Multiuser - Access database record locking in VB6

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access database record locking in VB6

hamptondude

2006-01-11, 1:24 pm

How do I lock a record so that only one person at a time can make
changes but any number can view the record at the same time?

Alex Dybenko

2006-01-12, 7:24 am

Try to set form RecordLocks property to "Edited Record"
for recordset - you can open it with pessimistic lock
--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"hamptondude" < hamptonsoft@optonlin
e.net> wrote in message
news:1137005386.409944.133280@g14g2000cwa.googlegroups.com...
> How do I lock a record so that only one person at a time can make
> changes but any number can view the record at the same time?
>

Sponsored Links