Invalid Argument error when trying to view a query in design mode

[smorgan77]

I'm using Access 2003 and my queries have never failed me before, I've run the same ones for the past year now without any problems. Now today all of a sudden I can't even view the queries in Design Mode. I get an "Invalid Argument" error. I can't even refresh my linked tables (linked through ODBC), I get another error similar to the Invalid Argument. All I want to do is run these queries. Does anyone have any suggestions? I've resorted to redoing the entire DB, but I wanted to copy at least one of the queries to use.

 

[genomon]

Sounds like the mdb is corrupt. First, try compact & repair. If no love there, try creating a new mdb and importing objects from the old one at a time, testing each to see if they are usable.

When everything is coming your way, you're in the wrong lane.

 

[GingerR]

Or restoring your backup copy...

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[genomon]

BINGO GingerR!
Nice save!


When everything is coming your way, you're in the wrong lane.