MS SQL Server ODBC - Access update query to SQL fail

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access update query to SQL fail

gdonald20

2006-03-13, 7:23 am

Hi

I'm using and odbc link to link my sql tables to my access database.

I have created a set of update queries to move my data from Access to SQL.

Two of these queries fail on all of the records saying there has been a key
violation. These 2 tables have a 1 to 1 relationship and it doesn't matter
which or i try to update the records in, it always fails.

Can anyone shed any light on this problem?

Thanks

Gillian

Sponsored Links