Invalid Argument in select queries

[Guest]

On Friday I posted this:
--An Access 2003 query that has been working fine, began throwing Error 3001,
Invalid Argument when it is run. It is a Make Table Query, and when 2
particular fields are included in the query, it gives this error. Without
them, it runs fine. Both fields are "memo" type fields, but as I said, it
has been working fine until this week or so. Any ideas?

--P.S. I searched the Knowledge Base, it says that error occurs when the
Database is larger than 2 GB.
My DB is ~290,000 KB, well below this limit.

Today I came in and one of my select queries is giving me the same error. I
am at a loss. has anyone else had this happen?

 

[[MVP] S.Clark]

Repair and Compact lately?
Is the database split? (Corruption can occur when it isn't)
I'm not a fan of Memo fields, do you have to use them?
If you import the table(s) and query to a new mdb, does the error come with
them?

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"Corey "Leonard" Pendleton"

 

[Guest]

thanks for your help the compact and repair idea worked for me.