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

We'll call during UK business hours

Name:
Number:
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


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

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:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips



Access training London
Course rating
4.8 stars - based on 4042 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