Frequent timeouts on SQL Server
Posted on 2009-04-15
I have a Microsoft Access database that uses linked tables from a copy of SQL Server 2000 (via ODBC). When running insert or delete queries on one of the tables, I frequently get errors, primarily timeouts.
Here's one example:
Run-time error '-2147217871 (800040e31)':
[Microsoft][ODBC SQL Server Driver]Timeout expired
This is not terribly consistent, but it frequently happens when I delete two records in a row. According to SQL Server Enterprise Manager, there's a lock on it from a select query when this happens.
I can't have the database timing out when adding/deleting records... Any idea what I need to do to prevent the delay/lock from happening?