Error: Operation must use an updateable query.

[cdck]

I have the following query:

[tt]UPDATE dbo_SalesOrders INNER JOIN SOcaptureTransfer ON dbo_SalesOrders.fsono=SOcaptureTransfer.fsono SET dbo_SalesOrders.fstatus = SOcaptureTransfer.fstatus
WHERE (((dbo_SalesOrders.fstatus)<>(SOcaptureTransfer.fstatus)));[/tt]

Every time that I run it, I get the error:
"Operation must use an updateable query."

I tried creating a simple update query that just changed one field in dbo_SalesOrders to equal "HERE" if another field equalled "PA", and got the same error message:
[tt]UPDATE dbo_SalesOrders SET dbo_SalesOrders.test = "HERE"
WHERE (((dbo_SalesOrders.fstate)="PA"));[/tt]


I am able to run an append query on this same table without any issue, but it appears that I cannot run an update. Even this query gets the same message:
[tt]UPDATE dbo_SalesOrders SET dbo_SalesOrders.test = "HERE";[/tt]

Does anyone have any idea what could be causing this error? The table is a linked table stored in a SQL server, and the connection uses a system DSN, which has full permissions on that table.

Cheryl dc Kern

 

[PHV]

Does access recognize the primary key of the SQL table ?

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

 

[cdck]

Thank you. No, it did not. I added a timestamp field for access to use, and now I can update as needed!

Cheryl dc Kern