Re: Allow Zero Length String Property - 2000 vs 2003

From: Brendan Reynolds (brenreyn)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 17:56:17 -0000

I can only assume that it was a misguided attempt to 'protect' inexperienced
users from having to deal with Null values. If so, it was of course doomed
to failure, as they will sooner or later have to deal with Null values in
numeric or date fields anyway.

Are you the same person who posted the 'Allow Zero Length String in MS
Access 2002 and 2003' post? If not, be sure to check out that thread if you
haven't already done so. 

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Ash" <Ash@discussions.microsoft.com> wrote in message 
news:2EDDB913-E7FA-4BA7-9CED-425292A6A7A9@microsoft.com...
> Hello,
>
> I created a table using MS Access 2003 (Which uses Access 2000 format
> database), the default value for the attribute, "Allow Zero Length String"
> has been changed to Yes.
>
> Can anyone please verify, why it has been done?  Is there any way to 
> change
> this default.
>
> My two cents: For the past 6 years I am used to seeing the default  for
> "Allow Zero Length String" to No.  Changing all of a sudden to Yes, broke 
> a
> whole lot of things.  It is extremely frustrating.  Why the folks at
> Microsoft do not get the concept of backward compatibility.  Actually, if 
> you
> look at every other relational database, Null value is what goes into a
> column, when you try to insert a zero length string.  With that in mind, 
> the
> defaul of No for the attribute made sense.
>
> I would appreciate the comments.
>
> -- 
> Ash

Relevant Pages

  • Re: Allow Zero Length String Property - 2000 vs 2003
    ... "Ash" wrote in message ... > database), the default value for the attribute, "Allow Zero Length String" ...
    (microsoft.public.access.tablesdbdesign)
  • REPRESENT revisited
    ... Forth-94 has few floating point display functions [none in the ... If u is greater than zero the character string shall consist ... If u is zero the string shall consist of one digit representing ...
    (comp.lang.forth)
  • Re: Reproducing java calculations in UNIX
    ... quotient goes in x, also a double. ... is greater than zero) only the fractional part of the ... {fraction is 52 zero bits, ... is converted from string to floating point (string ...
    (comp.unix.shell)
  • Re: REPRESENT revisited
    ... >has given rise to implementations that differ in critical ... The required compatibility is 1), but 2) makes it much easier to get ... > If u is zero the string shall consist of one digit representing ... But I think it is a very bad idea if a word that should fill a string ...
    (comp.lang.forth)
  • RE: Macro Question
    ... The string you want Microsoft Excel to search for. ... SearchOrder Optional Variant. ... The settings for LookAt, SearchOrder, MatchCase, and MatchByte are saved ... > include a search for occurrences of zero. ...
    (microsoft.public.excel.programming)
Loading