Indicator For Locking Types

Results 1 to 2 of 2

Thread: Indicator For Locking Types

  1. #1
    HW Guest

    Default Indicator For Locking Types

    Is there a built in function/object that would enable me to determine if I had locked a table? I want to retrieve records by using a locktype of adLockPessimistic. If another user tries to access the same table, I would like to execute code depending if the table is locked or not. Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Indicator For Locking Types

    The LockType property on the a recordset object will let you get/set the LockTypeEnum value... <BR><BR>intLockType = rstRecordSet.LockType<BR>If intLockType = adLockPessimistic Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;...<BR>End If

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts