Invalid Argument

[jo.stanley]

I have a database that holds 130,000 records and this has a number of make table queries - these are very simple queries which just find data after a certain date. However I can run the queries three times and then if I try to run them again they come back saying Invalid Argument. Does anyone know why this could be happening - If I reboot my computer and try again it will let me run them three times and then not again.

Please help

 

[SydneyGeek]

You wouldn't be using XP by any chance? I have some code that processes 4 separate macros in an Excel file -- or it used to in A97. Now the fourth one hangs.
I wonder if XP has a bug related to this problem?

Denis

 

[blueshark]

Are you running the same thing three times in a row? Or are you running it with different criteria. I usually get that when I have some bad data that's getting passed around or sending the wrong data type through a procedure.