I have had an append query that includes from & to date parameters that has
worked for 2 years. Now, today it halts & gives me an 'Invalid Argument'
message with this for the Help
- Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one
of the arguments to the routine is invalid. Check your entry to make sure you
have specified the correct arguments, and then try the operation again. This
error also occurs when you attempt to use mutually exclusive constants in an
argument to a method, such as specifying both dbConsistent and dbInconsistent
in the options argument to the OpenRecordset method.

If I open the query to view, I can see all of the records there that I'm
wanting to append into the table, but when I run the query I get the error.
Same thing happens if I change it to a make-table query - if I view I can see
it all but when I run I get the error.

I have rebooted and have tried to run it on different pcs but get same
results.

What could have gone wrong? Would it help if I got Little Richard to plead
my case? :-)

"melissas" <(E-Mail Removed)> wrote in message
news:13571301-6028-4526-B508-(E-Mail Removed)...
>I have had an append query that includes from & to date parameters that
>has
> worked for 2 years. Now, today it halts & gives me an 'Invalid Argument'
> message with this for the Help
> - Invalid argument. (Error 3001)
> You tried to perform an operation that involves a routine in a DLL, and
> one
<snip/>
> What could have gone wrong? Would it help if I got Little Richard to plead
> my case? :-)

Check the size of the database. It appears that your DB is 2GB.

Regards