F fredg Aug 23, 2005 #2 how many records can be stored in an Access 2003 table? Click to expand... See help. Help + Index + Specification + Access Specifications
how many records can be stored in an Access 2003 table? Click to expand... See help. Help + Index + Specification + Access Specifications
G Guest Aug 23, 2005 #3 There is no limit as it depends on the number of fields and th field types. The help in access on limits and sizes states this Table Size 2 gigabyte minus the space needed for the system objects
There is no limit as it depends on the number of fields and th field types. The help in access on limits and sizes states this Table Size 2 gigabyte minus the space needed for the system objects
A Albert D.Kallal Aug 24, 2005 #4 The size limit of access 2002 is 2 gigs. So, if you take a average name in a mailing list, add a few extra fields...your record size might be about 120 characters on average in size. So, the number of records you can store is: 2 gig / 120 = 32 million records So, the limit is NOT the number of records..but "how many" records you can fit into 2 gig. Of course, if each customer name only takes up 60 characters...then you can store 64 million records in the file.
The size limit of access 2002 is 2 gigs. So, if you take a average name in a mailing list, add a few extra fields...your record size might be about 120 characters on average in size. So, the number of records you can store is: 2 gig / 120 = 32 million records So, the limit is NOT the number of records..but "how many" records you can fit into 2 gig. Of course, if each customer name only takes up 60 characters...then you can store 64 million records in the file.
