Invalid Argument

[mikew71]

I have an unusual problem, I'm continually getting an 'invalid argument' error when I attempt to run a query either based on or appending to a certain table. I've not come across this before and nothing seems to change this, any ideas??

 

[cascot]

mikew71,

Can you provide more information? Are you able to successfully run the very same query against other tables, and the "invalid argument" error only occurs when running against this particular table?

If the query contains any functions, check the contents of the fields being used as parameters to the function(s). There could be rogue data in there which doesn't conform to what the function expects.

How many records are contained in the problem table?

 

[TheEntertainer]

Hello,

You may have solved this by now, as I've been having exactly the same problem. It would seem that in my case it's related to the size of the database. Access has a 2GB limit. If I opened another database and ran the same code it worked fine, or if I removed some tables from my original access database it allowed me to run query etc (You may have to repair and compact).

I also found a link on another tek-tips question which might prove useful:

http://www.databasezone.com/techdocs/acclimit.html

Cheers