Ms Access size?

  • Thread starter Thread starter luis.a.roman
  • Start date Start date
L

luis.a.roman

What is the maximum size of a Ms access database? Is the maximum size
is 2GB? Or the max size of each table on access is 2GB?

Your collaboration with this question is appreciated.

Luis
 
Open Access
PRess F1 for Help
Enter "Specifications" as the search criteria.

The maximum size of any one Access database file is 2 gigabytes if you are
using Access 2000 or later. Before that was 1 gigabyte for 97. I don't know
what the limits for earlier versions.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
John Spencer said:
Open Access
PRess F1 for Help
Enter "Specifications" as the search criteria.

The maximum size of any one Access database file is 2 gigabytes if you are
using Access 2000 or later. Before that was 1 gigabyte for 97. I don't know
what the limits for earlier versions.
Click to expand...

I'm reasonably sure the limit was 1 GB for Access 1.0, 1.1, and 2.0, as
well, John.

Larry Linson
Microsoft Office Access MVP
 
Back
Top