Append query key violation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings and thanks!

I am uploading some data into a SQL 2k DB linked to MS Access 2003 .mdb
application. The table I am trying to upload to is currently empty and is a
connection or interface table with two FK ID columns.

When I click the append button, I get an error message that none of the
records were added because of key violations.

I went into the SQL table and temporarily eliminated the keys on the two
columns. Same error.

Any suggestions? Thanks
 
sometimes it happen when you have a field that doesn't allow null value, and
when run the query there is no value added to that field.
 

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

Manage append query key violations? 4
Access 2010 append query to SQL is very slow 0
Figuring out what field is causing key violation on append 6
Append Query - Key violation 1
key violations 4
Append Query Key Violation 5
Append Query key violations... Autonumber entries 4
Append query key violation 8

Back
Top