VALIDATION RULE PROBLEMS WITH AN ACCESS 2000 UPDATE QUERY

[Guest]

Designed a simple Access 2000 update query to append records from one table
to another table. Keep getting a message that the append failed because of
validation rule violations. Have matched the table definitions precisely and
see no validation conflicts, but still no appending occurs. Any ideas?

 

[Ken Snell [MVP]]

Check that all fields that are Required have values; check for duplicate
values where they are to be unique, check that fields that say Not Allow
Zero Length don't have Null or empty string values, etc.

 

[Guest]

I have the same problem. I have carefully checked all the factors you listed.
I still get validation errors that block the appending of records. This
appears to be the result of a null field in the record to be appended. If I
drop the null field from the append query or hard code it to a character (say
an underscore) it works. However, dropping the field or hard coding
characters is not an acceptable workaround for this for me.

 

[Ken Snell [MVP]]

Then can you set the Required property for that field in the table (table
design view) to No? If not, then you've no choice but to include some value
for that field in your query.
--

Ken Snell
<MS ACCESS MVP>

 

[Guest]

Required Property IS set to NO!

Then can you set the Required property for that field in the table (table
design view) to No? If not, then you've no choice but to include some value
for that field in your query.

 

[Ken Snell [MVP]]

Is the Allow Zero Length property set to No? I know that you say you checked
all the properties, but what you describe would result if Required property
is set to No and Allow Zero Length property also is set to No. If you set
Allow Zero Length property to Yes, that likely will fix your validation
problem.
--

Ken Snell
<MS ACCESS MVP>

 

[Guest]

I had the same problem. I went through and check all the fields in the
destination table and made sure they allowed "Zero-Length" and that they were
not required and that did the trick. (this included fields not directly
effected by the append query)

 

[JORJE ALONSO]

I had the same problem. I went through and check all the fields in the
destination table and made sure they allowed "Zero-Length" and that they
were
not required and that did the trick. (this included fields not directly
effected by the append query)