Size Limitations

J

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.
 
D

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.
 
J

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.
Click to expand...

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]
 
Top