Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training - Maximum number of records (rows) stored in Access table

microsoft+access+training - Maximum number of records (rows) stored in Access table

ResolvedVersion Standard

Tue 28 Nov 2006, 14:23 Delegate Srinivasa said...

Srinivasa has attended:
No courses

Maximum number of records (rows) stored in Access table

Hi

I need to know Maximum number of Records(Rows) , I can store in a table.

and also number maximum rows for Pivot table.

Thanks & Regards

Reddy

Tue 28 Nov 2006, 16:37 Trainer Garry said...

RE: Maximum number of records (rows) stored in Access table

It's not the number of rows(records) that matter, it's the amount of storage capacity. Database (.mdb) file size 1 gigabyte.

there are tables that reach 1000 000 records... and works good

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

microsoft+access+training - Maximum number of records (rows) stored in Access table

Maximum number of records (rows) stored in Access table

RE: Maximum number of records (rows) stored in Access table

Access articles

Access tip:

Convert A Form Into A Report