How do I create an update query with a linked table to a local table??

[anhfuego]

when I try to create an UPDATE query using one table as a 'LINKED dbo table' to a local table to be updated, the system pops a prompt stating that the query that is getting updated is unupdateable.

please help, thanks.

anhfuego

 

[PHV]

Any chance you could post the SQL code of this unupdateable query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886