Append Query

G

Guest

Hi. I am trying to append one table to another both existing in the same database, but when I tyr to run the query it gives me a veyr long error message! It says" Microsoft can't append all records at this time. Access set 4 fields to Mull due to a type conversion failure & it didnn't add 0 records to the table due to key violations, 0 records due to lock violations & 0 due to validation rule viloations" WHAT! ?????? Thanks!
 
K

Kevin Kennedy

4 fields to Mull due to a type conversion failure
Are the data types for the each field that you are updating from the same as
the field that you are to? e.g both dates etc.

Tina said:
Hi. I am trying to append one table to another both existing in the same
Click to expand...
database, but when I tyr to run the query it gives me a veyr long error
message! It says" Microsoft can't append all records at this time. Access
set 4 fields to Mull due to a type conversion failure & it didnn't add 0
records to the table due to key violations, 0 records due to lock violations
& 0 due to validation rule viloations" WHAT! ?????? Thanks!
 

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

Similar Threads

Access 2002 Append Query Problems 1
How do I avoid key violations in append queries 7
Running into error while writing Append Query 2
Type conversion failure on Append 12
Access Can't Append Message 3
Append query wont run because: 8
Remove warning pop up choice 4
Append Query not work 2

Top