Size Limitations

[Jim]

Are there any limits to the number of records a table (or
the database as a whole) may contain? I have data that
will become almost 15 million records. Thanks.

 

[Douglas J. Steele]

The only limits in Access is that a single MDB file can be no larger than 2
Gb (1 Gb for Access 97 and earlier), and that a single row cannot exceed
2000 bytes.

 

[John Vinson]

Are there any limits to the number of records a table (or
the database as a whole) may contain? I have data that
will become almost 15 million records. Thanks.

See the Help topic "Specifications". There is no explicit limit on the
number of records, but any single .mdb file (or MSDE "SQL Server Lite"
database) is limited to 2 GByte.

15 million is pushing the size that I'd want to look into
client-server. I'm aware of some Access applications with larger
(20,000,000 row) tables but they're few and far between and require
careful design and implementation.

John W. Vinson[MVP]

 

[Jim]

Thanks for all the help. I'll keep this in mind during
my design.