RussellEngland
New member
- Local time
- Yesterday, 19:17
- Joined
- Sep 9, 2008
- Messages
- 2
Hi chaps
I'm running a little routine to import data from txt files. Its been running well and has processed 115,000 records until I got this error:
run-time error -2147467259 (80004005) "invalid argument"
The code with the error is
oconnect.Execute("insert into BookFields(Regno, FieldName, FieldValue) values(1066704,""XXXXXX"",""XXXX"")")
If I copy and paste the above into the debug window, I get the same error.
If I replace the values, I get the same error so it can't be the data.
If I stop and restart the program, it happens again almost immediately but with a different set of data.
I tried creating a copy of Bookfields with no data - restarting the program and got the same error after 340 records
The connection string is
dim oConnect as new ADODB.Connection
oConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & CurrentDb.Name & ";"
Any ideas?
Thanks
Russ
I'm running a little routine to import data from txt files. Its been running well and has processed 115,000 records until I got this error:
run-time error -2147467259 (80004005) "invalid argument"
The code with the error is
oconnect.Execute("insert into BookFields(Regno, FieldName, FieldValue) values(1066704,""XXXXXX"",""XXXX"")")
If I copy and paste the above into the debug window, I get the same error.
If I replace the values, I get the same error so it can't be the data.
If I stop and restart the program, it happens again almost immediately but with a different set of data.
I tried creating a copy of Bookfields with no data - restarting the program and got the same error after 340 records
The connection string is
dim oConnect as new ADODB.Connection
oConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & CurrentDb.Name & ";"
Any ideas?
Thanks
Russ