blank values giving me validation error in append query

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
 
K

KARL DEWEY

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.
 
T

Ted

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.
 
R

Ron2006

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top