What is the Data Storage capacity of Access

[Guest]

Hi All,

I know I am asking a very basic and silly question but this is of very much
importance to me if any one can help me.

Like in Excel we have a limitation of around 65000 rows, what is the
limitation in Access ie how many rows of records can it store.

Also is there a limitation on the size of the database also.

Thanks.

 

[John W. Vinson]

Like in Excel we have a limitation of around 65000 rows, what is the
limitation in Access ie how many rows of records can it store.

No explicit limit. I've used tables with 1.5 million rows, and am aware of
production databases with 20,000,000 row tables. Access can also serve as a
frontend to SQL/Server or other client/server databases with enormous
capacity.

Also is there a limitation on the size of the database also.

An Access (JET) database is limited to 2 GByte (2048 MByte).


John W. Vinson [MVP]