blank values giving me validation error in append query

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Hi all,

I'm probably doing something stupid here but here goes...
I'm running some append queries...if there is no value in some of the fields
I get a validation error and it says Access can't append all of the records.
The table that its appending to does not have the "Required" field set to
Yes for any of the fields.

Any ides? All of the data types of the table thats receiving the records are
Text.

TIA
Ted
 
Does the field have a Validation rule? If so, then add to it OR NULL so
it will accept nulls as valid.
Is it a foreign key in a one-to-many relationship? If so, then you got to
fill the blank.
 
Hi Karl...no none of the fields in the appending table have validation
rules and there are no primary or foreign keys.

I'm really at a loss here. I built a test db and tried to append records
w Null values to the table and it worked fine.
 
Can you double check the append validation error. If it is the error
message I am thinking of it gives you a whole sleu of reasons for an
error and tells you how many for each error. That may give you an idea
where to go.

Are any of the fields INDEXED with NO Duplicates?

Ron
 
Back
Top