microsoft access database error message (1 Viewer)

chedwo

New member
Local time
Today, 08:33
Joined
Nov 28, 2005
Messages
3
please help I am working with access database I have limited experience with access. I am unable to figure this particular problem. Microsoft access can't append all the records in the append Query microsoft access set 0 field to null set to convertion failure and didn't add 2 to records to the table due key violation 0 record due to key lock violation
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:33
Joined
Feb 19, 2002
Messages
42,981
Two of the records you are trying to append have keys that are identical to records that have already been added.

You can identify the duplicates by running a "find duplicates" query (the wizard will build it) on the source table.
 

chedwo

New member
Local time
Today, 08:33
Joined
Nov 28, 2005
Messages
3
thank you
I will give it try
 

jarhead123

New member
Local time
Today, 08:33
Joined
Jan 10, 2008
Messages
1
error message -can't append all the records in the append query

Please help me as well. I am working with access database I have very limited experience with Access. Microsoft Access can't append all the records in the append Query microsoft access set 0 field to null set to convertion failure and didn't add 2841 records to the table due key violations 0 record due to key lock violation.
Would this also indicate duplicate records in the table....?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:33
Joined
Feb 19, 2002
Messages
42,981
Key violations are generally duplicates. Did you run the append query more than once?
 

Users who are viewing this thread

Top Bottom