Unexplained Error "Invalid Argument"

[Rita Palazzi]

Windows XP Professional
Office 2000


I have an append query that has been used for several years. All of a
sudden, when the query is executed, I'm getting an "Invalid Argument"
error. Nothing has changed in the query. All it does is append the
results of a query into a table in another database. The table has not
been changed. I've tried to recreate the query with no luck. Does
anyone have any idea on why an append query would give an "Invalid
Argument" error? And why would it work perfectly for years, then just
get an error?


Thanks in advance for any help you can provide!

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express

 

[Guest]

If your argument is derived from a table, form, or query and they have
changed then it can be invalid.

Post your query SQL and someone might be able to suggest where to look for a
solution.

 

[Rita Palazzi]

Nothing had changed, but like I said, have used this for years. Hence,
database the query was writing to was at its size limitation (over 2GB).
I saved the existing archive database as a backup and created a new
one. This solved the problem.

Thanks!!