Maximum Database size

[Mohapi Taole]

What is the maximum size of a Access database and what options do I have if I reach the limit?

[June7]

Access size limit is 2GB. Options:

split the database, frontend has queries, forms, reports, code and links to tables in backend - if the backend exceeds 2GB, options are:

1. split tables into several backend files - this does present other data management issues

2. migrate the backend to a larger capacity database app - SQLServer, Oracle, etc.
SQLServer Express is a free version of SQLServer. I think Express size limit is now 10GB.

[DaveC]

Is there a direct correlation between number of records and the database size? I have an Oracle table with about 15 million records that I want to import into Access and I don't know how large that will be.

[June7]

No direct correlation with number of records - although it can be an indicator. 15 million does sound like a lot of data. Need to know how big in GB that table would be. Can try the import and see what happens. Why import from Oracle?