Invalid argument. (Error 3001) in Access

[Cat]

Dear All

I m encountering problem when I try to run a query. I
receive an " Invalid Argument" message.

The Help section indicate it is an error 3001 with detail
as follow:-

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 met

Hope I could have your expertise to solve the problem.
Many thanks in advance

 

[Dirk Goldgar]

Dear All

I m encountering problem when I try to run a query. I
receive an " Invalid Argument" message.

The Help section indicate it is an error 3001 with detail
as follow:-

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 met

Hope I could have your expertise to solve the problem.
Many thanks in advance

Does it happen when you try to run *any* query, or just one in
particular? If the latter, please post the SQL of the query. Does it
happen when you run the query in VBA code? If so, please post the code.