Invalid Argument (1 Viewer)

[stuartd2]

I am running a Macro on Access2000 - on a NT4 server (SP6). It downloads base tables from our AS400 legacy system using ODBC linked tables and running a make table query.

It has suddenly developed a quirck where it comes up (sporadically) with a really helpful error message that simply says "Invalid Argument"

Help please

 

[Pat Hartman]

Since macros don't allow error trapping, I avoid them like the plague. Try converting the macro to code (use the menu option under macros if you like). Then put in error trapping and you should be able to at least identify which query is causing the problem.