Locking a table

Results 1 to 2 of 2

Thread: Locking a table

  1. #1
    Join Date
    Dec 1969

    Default Locking a table

    I have a &#039;dumb question&#039; that none of my overpriced reference material will give me a straight answer on: how do I grant an ADO connection exclusive access to a table?<BR><BR>I just want to ensure that when two connections are trying to access the same table the latter will be forced to wait until the former has finished before it can even read data (not just write).<BR><BR>I&#039;m using MSSQL 2000 and ADO 2.5.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default When you open the recordset

    open it with a pessimistic lock...R&D adLockPessimistic

Posting Permissions

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