Stuart McLachlan
stuart at lexacorp.com.pg
Sat Feb 21 21:35:29 CST 2009
It's not that bad. It's ony 300KB Take a look at your Processes in Task Manager. Load an instance of Access and you load up about 9 - 10MB.. Load an MDB and it goes up by about another MB Just open one fairly simple form and you add about another 500KB Even if you only have 1GB of RAM, which is really the minimum requirement these days, You are talking about a 3% increase in the RAM requirement. for the application and .03% increase in overall RAM utilisation. -- Stuart On 21 Feb 2009 at 20:52, jwcolby wrote: > Well... you just convinced me not to do that! > > ;-) > > John W. Colby > www.ColbyConsulting.com > > > Stuart McLachlan wrote: > > Len() measures in characters. > > > > Access stores string data as a 10 byte header, followed by the character data in Unicode, > > using 2 bytes per character > > > > So 2500 strings with a total length of 140,000 character will take > > (2,500*10) + (140,000*2) = 305,000 bytes. > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com