SQL Server locked record problem

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

Guest

I have a lot of queries on linked SQL server tables. One linked table in
particular causes problems for queries if any of the records are in use.

How can I run queries on linked SQL server tables without them crashing when
a record is locked?

TIA

Vaughan
 
Did you try changing this queries to a pass through query, if all the tables
that are used placed on the sql derver, then the prformance of the query will
mush better.
 
Often, a locking problem on SQL-Server arises when it puts a TabLock instead
of a RowLock or a PagLock and this will happens if the number of locks is to
big (lock escalation) or if it does a full table or an index scan instead of
a range scan.

It is then possible that you may solve your problem by taking a close look
on the indexes defined for your table and the nature of the query made by
Access.

However, you should also know that using linked tables for manipulating data
on a SQL-Server is a very limited way of doing things.

As the other post suggested, using a SQL pass-through may also solve your
problem.
 
Back
Top