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
 
Back
Top