microsoft+access+training - maximum number records rows
Request a callback

We'll call during UK business hours

0207 987 3777

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

resolvedResolved · Low Priority · Version Standard

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

Srinivasa has attended:
No courses

Maximum number of records (rows) stored in Access table


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


For upcoming training course dates see: Pricing & availability

Tue 28 Nov 2006, 16:37 replyReply 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


Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Training courses
London & UK

Live dates & prices »

On-site training

Get a quote »


Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access training London
Course rating
4.8 stars - based on 4644 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom