"Invalid Argument" Error Message

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

I get this message when trying to look up stuff in a
database that I am using. The database, however is over 2
gig and there are several memo fields in the tables. I
have eliminated the problem in some tables by removing the
memo field. What else may cause this problem? Is MS
Access designed to handle databases this large?
 
It depends on your version of Access, but the limit is 1 GB or 2 GB, so
you're over both. I would recommend creating a new file and import what data
you can from the current file. Is this new file over 2 GB? If so, you will
probably need more than one data file for the tables and link them to a
"front-end" file for the user interface. Have you compacted and repaired
your file lately? If not, it may be worth a try, but not until you make a
copy of it and have imported the data into another file for safe keeping,
since you're over the size limit, I'm not sure what would happen.
 
Back
Top