validation rule violation 2

[kerrigirrl]

i'm getting an error on an append query, "cannot add 1046 records due to validation rule violation". i'm using 3 files to append to the table. NONE OF MY TABLES HAVE VALIDATION RULES or input masks! is there any other reason i would be getting this error?

thanks in advance,
kerri

ps - this query has been running fine for days, no changes that i know of to query or tables. all fields are text except for 2 number (double) and 1 date/time with no format.

 

[dawolter]

kerri,

Make sure the text columns in your table "Allow Zero Length"

 

[rccline]

I received the same message when trying to run an append query. Changing all the table properties to allow zero length resolved the error.

How could I have set the query to change null to zero, so that the query would have run without having to change the "allow zero length" fields.

Is there an advantage of doing it either way?

Why would a designer (in this case records from Outlook) create fields that don't allow zero length, but are so likely NOT to have data input into the fields?

Thank you.

Robert

 

[MichaelRed]

The allow zero length fields property of database fields in Ms. A. defaults to "NO". Many (most?) Ms. A designers / programmers forget to even think about the implications - much less set this field property, as well as some of the others.

Testing of many functions in Ms. A. db land is somewhere between minimal and non-existant.

Ms. A. land is hugely over-populated with pseudo professionals who have NO formal background in any programming language or db. It is one of the major reasons (IMHO) that Ms. A has a bad rep in (real) professional programming circles. There are more horror stories than anything resembling sucess - and many (MOST?) stem directly from the use by the hordes of un-knowledgeable users.

These forums (actually the questions and some of the responses) are mostly from students and the pseudo professionals, and thus are prime examples of the level of professionalism found in the Ms. A world.

Please excuse the RANT, must be a bad morning (for me). To many questions (posts) where the answer would be found much more quickly with a simple reference to HELP. In some instances the Help answer would be more complete and accurate.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over