"Invalid Argument" Error Message

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?
 
W

Wayne Morgan

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.
 
Top