Access update query to SQL fail

Access update query to SQL fail

This is a discussion on Access update query to SQL fail within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi I'm using and odbc link to link my sql tables to my access database. I have created a ...

		Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC
Access update query to SQL fail

#1 (permalink)

02-27-2008, 10:08 PM

=?Utf-8?B?Z2RvbmFsZDIw?=

Posts: n/a

Access update query to SQL fail

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

« creating a link server into oracle | SQL server stops responding to new connections »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 03:41 AM.