Accessing data in sql server without a record lock
Posted on 2014-10-24
We have a bit of a problem with locks in SQL server at the moment. I'm trying to access the data in readonly, and I'm having a bit of a problem. Even as I access it in readonly, it still makes a lock on the record it seems. I'm testing this in access at the moment because it is what I'm used to. I'm using an SQL passthrough query to get data from a read only view. I'm using the options (dbOpenSnapshot, dbReadOnly) to open the recordset.
Any of these options should prevent a lock on the record. But they all lock my record and I cannot update it next.
Im doing this on a windows 7 computer.