Ms Access size?

[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

 

[John Spencer]

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

 

[Larry Linson]

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.

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