Invalid Argument

[salemnj1]

I link Oracle tables via ODBC and run queries against them. The queries have always worked fine in the past, but now I am getting "invalid argument" error.

It is strange, I can run the query, see the result, but if I actually try to save the query, or output the data to a text file, or make a table with the data, I get "Invalid Arguement".

<img src=http://i38.photobucket.com/albums/e118/salemnj1/invalidargumenteror-msaccess2.jpg>

Anyone have an idea what could be going on?? It is happening with even the most simple queries.

 

[VicRauch]

When I see a problem like this, I generally call Microsoft Tech Support. You get two free calls with every installation of Access. If they can not help you fix the problem, the call will be escalated to more senior personnel until the situation is fixed.
Good luck!

 

[Andrew Fergus]

Hi

If you don't have any luck on the phone there are some articles here that may help :

http://support.microsoft.com/kb/263946/en-us
http://support.microsoft.com/?id=302495
http://support.microsoft.com/?id=835416

HTH, Andrew

 

[salemnj1]

great advice!

my problem isn't fixed yet, but i've put a help desk ticket in for a service pack 1/1a install.

i checked the tables i'm pulling from and yes i see that there is a numeric field that is set to decimal as the field size... i bet that is the culprit.