Error: Operation must be an updatable query!!!

[AT76]

Hi,

I'm trying to run an Update Query to a SQL View. I do have access to write to this view but when trying to execute the QRY I get the error message: OPERATION MUST BE AN UPDATABLE QUERY.

I'm not sure how to go about fixing this. Any Suggestions?
I have attached the SQL String code generated by ACCESS.

UPDATE dbo_V_ASN_ERRORS SET dbo_V_ASN_ERRORS.WORKSTATUS = "b"
WHERE (((dbo_V_ASN_ERRORS.ERRORPO) Not Like "CR*"));



Thank you!!!

 

[PHV]

And what about this ?
UPDATE dbo_V_ASN_ERRORS SET WORKSTATUS = 'b'
WHERE ERRORPO Not Like 'CR%';

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

 

[AT76]

Same error PHV. Thanks.

 

[Golom]

Maybe it hates the LIKE operator

UPDATE dbo_V_ASN_ERRORS SET WORKSTATUS = 'b'
WHERE Left(ERRORPO,2) <> 'CR';