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 tryr to run the query it gives me a very long error message! It says" Microsoft can't append all records at this time. Access set 4 fields to Null 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
 
"Access set 4 fields to Null due to a type conversion failure "

My guess is you tried to stick a text field into a number field, or some
such mix-up..Verify each source and destination "pair" have the same
datatype...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Tina said:
Hi. I am trying to append one table to another both existing in the same
Click to expand...
database, but when I tryr to run the query it gives me a very long error
message! It says" Microsoft can't append all records at this time. Access
set 4 fields to Null 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
 
Just answer YES, you'll see the query *should* work then.
It's just a warning message.
-----Original Message-----
Hi. I am trying to append one table to another both
Click to expand...
existing in the same database, but when I tryr to run the
query it gives me a very long error message! It says"
Microsoft can't append all records at this time. Access
set 4 fields to Null 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