I've been receiving a "database may be corrupt" error, when trying to run a query on a large database.
The size is approximately 2GB, and when I do a "compact and repair" on the database, it usually allows me to finalize what I was trying to do previously.
Is there a size limit on Access databases. I thought that 2GB would be fine, but apparently not.
If I store all my data in a different Access database, and simply link to those tables...will I run into the same problem?
Thanks for any help!