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:

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 LondonCould not connect to admin db:

Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Line: 5152
Actual SQL Query: insert into best_datarating (datarating_ID, datarating_AttachType, datarating_AttachID, datarating_Variable1, datarating_Variable2, datarating_Rating, datarating_Sample) values (null, "application", 2, 0, 0, 0, )
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/forum.php
Query string from URL: fpost_id=237

(Can not yet provide accurate rating)
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