Invalid Argument

[bob120579]

I get an "Invalid Argument" error when trying to run a query from a report with a parameter in the query which prompts for a last name to run the query.

When I take the parameter out of the criteria line of the query the query runs fine and returns all records. This only happens when there are users in the database or accessing that same table which the query runs off of.

Does anyone know what this problem is and how to correct it??

This is the information I get when clicking Help....

Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one of the arguments to the routine is invalid. Check your entry to make sure you have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive constants in an argument to a method, such as specifying both dbConsistent and dbInconsistent in the options argument to the OpenRecordset method.

 

[PHV]

Any chance you could post the parametized criteria line ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bob120579]

[Please enter the Students Last Name]

This is what is in the LastName field. I even get the message when I take this out of the criteria and enter a constant value such as "McKay". When I take all criteria out, the query runs fine with all records.

 

[bob120579]

Anyone have any suggestions?

 

[lespaul]

can you post the SQL too?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[jaaret]

See message with the subject, "Error 3001", which helped me diagnose why I was getting this error. I discovered my database had swelled to 1.99 Gigs and Access has a 2 Gig max. The problem is I am unable to compact my database. When I attempt to I get this error:

“Table ‘TempMSysAccessObjects’ already exists”

It will not compact. Is my only option to attempt to split my database?