[AccessD] On DB Bloat, Bad DB Design, and various

John W. Colby jwcolby at colbyconsulting.com
Fri May 21 18:53:34 CDT 2004


You know, that's fascinating.  I typically set the field size to 255 and
forget it.  The person can enter whatever length they need in Address1,
Address2, last name, first name etc.  Of course I use memo fields for the
paragraph length tomes that are sometimes needed.  I have never seen (to my
knowledge) a failure to write the data.  I think I will go off right now and
test what error I see when I intentionally try and save a record with more
than 2K record size.

John W. Colby
www.ColbyConsulting.com

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






More information about the AccessD mailing list