Access 2013- Append Query PROBLEM!!

Question

Hello

When using database access, after creating an 'Append Query' to append data into a table (from a form), everything works fine but at the end of the whole process this error message appears.

I have ensured that the field data type matches the data I am trying to input onto the table.

Any ideas?Solutions?

Many Thanks

Answer 1

Sorry, but no we can't. We can't see your data. I gave you the best we could when I said this:

"But the only way you will tell is comparing the data against the properties of the fields. "

You open the table in design mode and check the properties, then you look at the data itself and see if there is any violations.

Answer 2

Hello Scott and Duane

Thank you for your quick replies!

I am afraid I do not understand what the problem is??!

Could you please talk me through step by step how to fix it?!

Many Thanks !

Answer 3

I should have added that I might open the table directly and attempt to type or paste the information into the fields in a new record.

Answer 4

The message tells you the problems. Its not a data type mismatch, but a validation rule violation. You have one record where the data in the source does not meet the requirements of the destination table. Duane guess is the same as mine. But the only way you will tell is comparing the data against the properties of the fields.

Answer 5

I expect you have attempted to add a zero-length string into a text field that doesn't allow it. There may be something else. It's next to impossible to determine the source of the error without seeing the tables and data.

If you are appending multiple records, I would try limiting the records to determine the offending record.