Lonnie Johnson
prodevmg at yahoo.com
Wed Oct 19 13:29:48 CDT 2005
Thanks Drew for that breakdown. DWUTKA at marlow.com wrote: And just for an example Lonnie, the size limit of a text field. It's 255. When Jet actually writes the data for a text field, it writes the first byte to represent the size of that field. For example, if you had a table like this: Field1: Happy Smiles A Howdy, how are you? Inside the .mdb file itself, you would have this information: (I will use Asc(*) to represent a byte with the value represented by the asterick) Asc(5)HappyAsc(6)SmilesAsc(1)Astuff>Asc(0)Asc(19)Howdy, how are you? That way, when Jet is reading the table, it reads the first byte, then it reads that number of following bytes to retrieve the data for that particular field. Thus the limit of 255 characters in a text field. Drew -----Original Message----- From: Lonnie Johnson [mailto:prodevmg at yahoo.com] Sent: Tuesday, October 18, 2005 12:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Why 255? I knew that was some cool geek explanation. I love this stuff. Gary Kjos wrote:Hi Lonnie, Hexidecimal FF = 255. Or actually binary 11111111 = 255 it's the largest number you can express in a single byte GK On 10/18/05, Lonnie Johnson wrote: > I know this is going to be an easy one for most of you? I am a developer but I don't know this. Why does Access have some limits of 255 for a lot of things such as number of fields in a table, number of concurrent users and so forth? > > Just curious. > > > > May God bless you beyond your imagination! > Lonnie Johnson > ProDev, Professional Development of MS Access Databases > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- 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 May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free.