Hello,

I have the folowing problem that has me well and truly stumped :

I have an access dbase with a SQL backend containing one table , which has 32 million records. The access dbase has an append query that appends data to that table. This query fails giving the following messages :

1 Insert into linked table failed
2 ODBC timeout (0)

I have set the ODBC timeout on Access to 0 and 30000 and neither makes any difference. I can write one record to this table via an append access query fine, but not the full lot (circa 100000 records)

I would welcome any suggestions or comments

Thank you

DVNC