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
Resolved · Low Priority · Version Standard
Tue 28 Nov 2006, 14:23 Reply Delegate Srinivasa said...
Srinivasa has attended:
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
Tue 28 Nov 2006, 16:37 Reply 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 training LondonCould not connect to admin db:
(Can not yet provide accurate rating)
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
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
Connect with us: Google+
© 2015 Best STL. All
Rights Reserved. info
All prices offered for business users and exclude VAT. E&OE · Terms
2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
Reference: Med | Ses 1 | Coo Array
[medium] => 1