Timeout from access to SQL server connection

  • Thread starter Thread starter lava
  • Start date Start date
L

lava

I have an ODBC connection from access to SQL server and
push data sometimes 100,000 records at a time. recently,
with no change in coding, I have been getting this error
from my access program during the transfer:


Runtime error '-2147217871 (80040e31)'
[Microsoft][ODBC SQL server driver ] timeout expired

I get this error while even trying to push through less
than 1000 records.

Any help would be appreciated.
 
Well, dificult to say without knowing all details, but typical reason can
be: table is locked by other process - other user edit record, or somebody
read big table, so it also locked
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URGENT:Error and timeout 2
URGENT ! database processing timeout 4
Access Timeout 5
SQL Server connection 17
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access Pass-through Query to SQL Server 6
URGENT: database processing error 2
Connecting to SqlServer 2005 Express 1

Back
Top