Max. file size for Access 97 -> 1 GB, Access 2000&2002 -> 2 GB FOR EACH particular "mdb" and this has nothing to do with the size of outside tables (Access or something else) that your tables are linked to.
Linked tables use minimum amount of space.
If you are using Access to store A LOT of stuff - knowing the size of any Access "mdb" is IMPORTANT!
Did I say "important"?
It is CRITICAL!
When limit (1 or 2 GB) is exceeded - Access WILL crash without warning and "swelled" Access DB (mdb) might be beyond repair and therefore data from it could be kissed goodby!
...and watch out for the Access "mdb" size!
In one of my Access 2000 apps. I have 36 linked tables, each linked to additional Access "mdb" of over 1 GB of indexed data. "Locally" in the application I could have just under 2GB of data but with linked tables I have over 40 GB. Not the best way perhaps, but with Acccess alone - against large datasets - the only way.
When querying - I am of course limiting the number of records that queries are returning, but this is common with anything that has to do with large files.
I am using a program that accesses an ACCESS 97 .mdb file. the file has stopped growing at 210 mb. We and things to it every day and it does not get ANY bigger. I have read the max file size is 1-2 Gb. I am affraid I am losing past data or date will be corrupted. HELP! what do i do to make it get bigger or take mor data?