Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

smorgan77

Programmer
Nov 15, 2007
8
US
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.
 
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.
 
BINGO GingerR!
Nice save!
[cheers]

When everything is coming your way, you're in the wrong lane.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top