3001 invalid argument

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

I have a form that calls a query. I get an "3001" invalid argument when
it hits the query. On closer investigation, I can't even open the query
in design view. I get the message. I have the same query running on
another machine running Access 2000 - The machine in question is running
Access 2003. Both machines are running Win 2k.

I can't see anything wrong or strange with the query. I can open all
tables in view mode; I thought it might be a corrupt table. I've
checked VB references and they are set up the same on both systems.

Any ideas?

Thanks in advance.

Jim
 
Jim, it sounds like something has gone wrong with the way Access is storing
information about the query. It may be possible to rebuild it from the SQL
statement.

1. Open the Immediate Window (Ctrl+G).
Enter:
? CurrentDb.QueryDefs("Query1").SQL
replacing Query1 with the name of the problem query.

2. When you press Enter, Access should show the SQL statement.
Copy it to clipboard.

3. Create a new query, no table.
Switch to SQL View (View menu.)
Paste the SQL statement in.
Test.

4. Switch to Design View (View menu.)
Lay the tables out the way you want them.
Save the query.

If that doesn't work, you will probably have to delete the query, and
recreate it from scratch.

To help prevent the query from corrupting, be sure to uncheck the Name
AutoCorrect boxes under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html
 
In my case, you get this error when your "Liant" Relativity software is
not installed on the PC which makes the ODBC connection to the Cobol
ISAM files used in this query...
 
Back
Top