Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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!
 
Back
Top