-
ODBC Error : Access - SQL (Big table) Urgent!!
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|