Isolation Level for SQL Server Linked Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

We have created an Access select query that is running against a SQL Server
2000 database.

We have set query properties for no locks; however, our Access Query is
blocking other users from accessing the SQL table.

What SQL Server Isolation Level is associated with the No Locks Setting? Is
there a way to achieve the Isolation Level of uncommitted read for a linked
SQL table?

Thank you in advance for your help!
 
Are you using a SQL Pass-Through query or a native Access (Jet) query? The
Jet queries tend to lock an entire page (sometimes an entire table!) while
performing their task, as Access must first bring ALL of the data from SQL
Server (even if you have placed constraints on it), then perform the
operation locally, finally sending the results back to the server, all the
while keeping a lock on it. This can be extremely time consuming, especially
if the table is large or multiple tables are being joined. Can you post the
code?
 
Back
Top