[AccessD] How big can table get?

Nicholson, Karen cyx5 at cdc.gov
Tue Jul 19 07:29:30 CDT 2005


I think if you have to ask then you probably should consider the back
end being in SQL server. 

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

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



-- 
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