Error while inserting data (Run time error - 3146

[abpatind]

I have a linked table from SQL Server 2000 database and a empty table, in Access 2000 database (.mdb file).

There are around 170,000 records, which I am trying to insert from Linked table (SQL Server 2000) to a empty table (in Access 2000) using append query.
When I run Append query, it gives the following error:-


Run-time error '3146'
ODBC - call failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired(#0)


Is anyone familier with this error?
How should I prevent this error?

Your assistance will be a great help...Thank You

 

[PCLewis]

How long does it take for the error to be reported?

The error is pretty self explanatory. when I have had this it has always been correct. There are registry settings you can use to force the timeout to be larger but generally the timeout it there to protect you and the database from an overly long query.

If you have no way to extract the data other than over a network cable (i.e. no remote control into the server or no way to get the data extracted to a file on the server for you) then you might have to consider breaking your append into chunks. Try appending 20,000 records at a time and see if that works.

What is the sort of netowrk link you have as well?