Invalid argument

[Guest]

I am getting the Invalid Argument message when I attempt to execute a query
with an exclusionary criteria. This is in a database that has been working
fine up till now! Does this sound like a data corruption issue?

 

[John Vinson]

I am getting the Invalid Argument message when I attempt to execute a query
with an exclusionary criteria. This is in a database that has been working
fine up till now! Does this sound like a data corruption issue?

I have no idea, and no way to get any idea, since you've posted
nothing that would help me get one.

Have you changed anything in the query?
Could you post the SQL view of the query?
Have you tried Tools... Database Utilities... Compact and Repair?


John W. Vinson[MVP]

 

[Guest]

Thanks for the response. This is a VERY simple select query. I'm not at my
office now so I can't copy it exactly. It's on the order of select CustID,
CustName from tblMaster where CustID < 10. It runs without the CustID<10
criteria, but produces the Invalid Argument error message with it. I have
written clean dummy queries and had the same results.

 

[Guest]

I have tried compact and repair.

I have no idea, and no way to get any idea, since you've posted
nothing that would help me get one.

Have you changed anything in the query?
Could you post the SQL view of the query?
Have you tried Tools... Database Utilities... Compact and Repair?


John W. Vinson[MVP]

 

[John Vinson]

Thanks for the response. This is a VERY simple select query. I'm not at my
office now so I can't copy it exactly. It's on the order of select CustID,
CustName from tblMaster where CustID < 10. It runs without the CustID<10
criteria, but produces the Invalid Argument error message with it. I have
written clean dummy queries and had the same results.

What's the datatype of CustID?

John W. Vinson[MVP]