[AccessD] How big can table get?

John W. Colby jwcolby at colbyconsulting.com
Tue Jul 19 07:25:30 CDT 2005


Yes, with the exception of memo fields which can hold anywhere from 0 to 32K
bytes.  A definition of how many bytes are required for each data type is
available out there somewhere.  Just add them up.  An MDB container can
contain 2gbytes IIRC.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, July 19, 2005 8:09 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How big can table get?


I have a table that I am going to be populating with data. I know the field
types and sizes. Is there a way to estimate the maximum number of records
the table can hold within the database?

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

 

No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.

FAX (432) 688-3799

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list