DWUTKA at marlow.com
DWUTKA at marlow.com
Fri May 21 13:37:12 CDT 2004
Oh no, haven't forgotten, but if the limit is 255, that doesn't actually affect the 2k character limit. Actually putting 255 characters in will, but not the actual field size definition. However, if you limit a field to 35 characters, because you think that's all a user will need, and one day they need to put in 36 characters....NOW you are preventing the record from being saved. I have found very few instances where there was an ironclad reason to set the maximum field size to something other then 255. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz Sent: Friday, May 21, 2004 1:02 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various "Unnecessary" size restrictions on fields ensure that a record can be saved. If you have more than 8 text fields at 255 characters per field, Access will refuse to save the record. Have you forgotten the the 2k character limit on record size in mdb files? Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >From: DWUTKA at marlow.com > >Actually I think that talking about Access training/experience is a valid >topic. > >Recently, I have helped a friend with his Access 'homework' from his MIS >course. I worked cheap (for beer <grin>), but it just kills me what they >are having students do. The 'instructions' for the assignments has them >naming tables with spaces, setting unnecessary size limitations for text >fields, etc. Just plain ugly. In fact one instruction was so goofy, I >completely bypassed what they were trying to do, and wrote some VBA to have >the same result. > >It is just flat out amazing that the world moves as it does. <grin> > >Drew _________________________________________________________________ MSN Premium includes powerful parental controls and get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt p://hotmail.com/enca&HL=Market_MSNIS_Taglines -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com