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

Jürgen Welz jwelz at hotmail.com
Fri May 21 13:02:19 CDT 2004


"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=http://hotmail.com/enca&HL=Market_MSNIS_Taglines




More information about the AccessD mailing list