Invalid argument error when running append query from code

[AC]

Hi

I've been running this Access 2000 code for a few years with no problems. Now when I run it it gets stuck on a piece of code that runs an append query and I get the message 'invalid argument'. I know this is bogus and I do have SR-1 installed
After that the code gets stuck in a different place with the same error - it did not get stuck in this place the first time so again something weird is going on. Can someone tell me the cause and solution for this

Thanks

 

[Allen Browne]

AC, the first thing to try would be to download and apply Service Patch 3
for Office 2000, and also Service Pack 8 for JET. Both available from
support.microsoft.com

If that does not solve the problem, please post back with the SQL statement,
how you execute it (RunSql in macro? Execute in DAO?), and details of the
error message.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I've been running this Access 2000 code for a few years with no problems.

Now when I run it it gets stuck on a piece of code that runs an append query
and I get the message 'invalid argument'. I know this is bogus and I do have
SR-1 installed.

After that the code gets stuck in a different place with the same error -

it did not get stuck in this place the first time so again something weird
is going on. Can someone tell me the cause and solution for this?