Your record locking option is set via the .LockType property of the Recordset Object. It gets confusing because the ADO provider determines what types are allowable. Here is a microsoft link that is a pretty good resource: http://msdn.microsoft.com/library/de...isualbasic.asp
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Records locks using VB and ADO to access AS/400 data
Collapse
X
-
Records locks using VB and ADO to access AS/400 data
I am converting an application from DDA to ADO. This app is written in VB6. I am having trouble with record locks. Can anyone point me to information on how to determine if a record is locked, how to lock and how to unlock a record using ADO. What I know about this for SQL database's does not seem to hold true for DB2 database's. Thanks.
Comment