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

Martin Reid mwp.reid at qub.ac.uk
Fri May 21 16:01:49 CDT 2004


Great to see Jurgens posts. Always give you something to think about.

Martin



----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, May 21, 2004 9:56 PM
Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various


Gasp! You're right! On reading your second post, I revisited my table.
All I did was insert a few words into each column and it worked. Then I
copied exactly 255 characters into the buffer and pasted it into the
previously created table, in each sucessive field. I was able to paste 4
copies successfully but the error came up on the 5th.

Learn something every day, if you're lucky! Thanks, Jurgen.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, May 21, 2004 4:32 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various


Having never heard this before, I created an Access table with 9 text
(255) fields and successfully added a row. Then I decided to add some
more fields to the table, all text 255. I quit at 20, where I was able
to add and edit a row.

This is Access 2002 so your results may differ. In this version, the 2k
limit is no longer. The database is Access 2000 style, so this must have
been true then too.

-----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
=http://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

-- 
_______________________________________________
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




More information about the AccessD mailing list