Operation must use updateable query problem

[jpl458]

Using SQL Server 8 with ACCESS 2003 front-end. There is data in an ACCESS table that I want to use to update a table on SQL Server. Tables are linked tables and I have check that connection and it is ok. I have run this operation a couple of time before, and it ran fine, but not this time. Created the update query in the query design window of ACCESS, a picture of which I will try to send as an attachment.

The query generates the following SQL:

UPDATE dbo_Master_Accounts INNER JOIN RCM ON dbo_Master_Accounts.Master_ID = RCM.Master_ID SET dbo_Master_Accounts.FirstName = RCM.FirstName, dbo_Master_Accounts.LastName = RCM.LastName, dbo_Master_Accounts.Address_Line_1 = RCM.Address_Line_1, dbo_Master_Accounts.City = RCM.City, dbo_Master_Accounts.State = RCM.State, dbo_Master_Accounts.PostalCode = RCM.PostalCode, dbo_Master_Accounts.Phone_Number_1 = RCM.Phone_Number_1, dbo_Master_Accounts.Phone_Number_2 = RCM.Phone_Number_2, dbo_Master_Accounts.Gender = RCM.Sex, dbo_Master_Accounts.Date_Of_Birth = RCM.DOB;

Tried reloading the table into SQL Server and rewriting the query but get the same result "Operation must use updateable query."

Took a screen shot to send but can't figure out how to attach, but hope the setup is ok, checked it a bunch of times - slowley.

Any help would be appreciated

If you need the screen shot tell me how to attach it.

Thanks in advance\\

jpl

 

[PHV]

Does both tables have a PrimaryKey from msaccess point of vue ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

Yes, they have, and have had, primary keys. In dbo_Master_Accounts it's Master_ID, in RCM it's sequence number.

jpl

 

[PHV]

Hopefully RCM.Master_ID is at least an unique index ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886