Re: Using AllenBrowne's AppAudit routine - getting errors with nulls

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Using AllenBrowne's AppAudit routine - getting errors with nulls
Date	2011-05-02 14:53 -0400
Organization	A noiseless patient Spider
Message-ID	<ipmujc$rgn$1@dont-email.me> (permalink)
References	(1 earlier) <ipml3n$p84$1@dont-email.me> <ipmngs$74n$1@dont-email.me> <ipmokm$5js$1@dont-email.me> <ipmoum$959$1@dont-email.me> <ipmqk8$rm1$1@dont-email.me>

Show all headers | View raw

BobAlston wrote:
> On 5/2/2011 12:17 PM, BobAlston wrote:
>> I may have found the solution here.
>>
>> http://www.access-programmers.co.uk/forums/showthread.php?t=157357
>>
>> Can't try until tonight when I get exclusive access to the database.
>>
>> bob
> That wasn't it.  all text fields allowed zero length.

As suspected:
 if zero-length-string is the problem, the error message is explicit:
"Run-time error '3315': Field 'Table1.textcol2' cannot be a zero-length
string."
Your error message refers to Nulls doesn't it?

The responder in that forum seemed very confused about nulls and zero-length
strings. They are not at all the same thing.

> But I found two text fields with Indexed = yes.  When I changed the
> Indexed=no, running with a test copy of the production table, it
>   worked. Yea!
>
Hmm - can't reproduce here, but time to move on, I guess.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-01 18:40 -0500
  Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-05-01 20:01 -0400
  Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 11:11 -0500
    Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-02 12:52 -0400
      Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:11 -0500
        Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:17 -0500
          Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:45 -0500
            Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-02 14:53 -0400
            Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 08:09 -0500
              Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 10:00 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 09:12 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 10:51 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 14:01 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 15:58 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 15:11 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 22:16 -0500

csiph-web