Posted on 2002-03-20
can you please help me in the following problem:
I have MS ACCESS DB that have a linked table to SQL Server, when I try to insert records from the ACCESS DB table into the SQL Server linked table,I get the following error:
ODBC-insert on a linked table 'Table Name' failed
[Microsoft][ODBC SQL Server Driver] timeout expires(#0).
I'm using SQL SERVER 2000 ,MS ACCESS 2000, the linked table(sql server side) has more than 30,000,000 records.