Last post Mar 26, 2011 09:32 PM by Decker Dong - MSFT
Mar 23, 2011 06:04 PM|hsl89|LINK
i'm getting this error while trying to run an acess query
Operation must use an updatable query. (Error 3073)what this mean and how can i solve this?
Mar 23, 2011 08:24 PMfirstname.lastname@example.org|LINK
Not sure what your query looks like so unable to really diagnose the problem however a quick google search yielded many results
Mar 24, 2011 08:11 AM|hans_v|LINK
Not sure what your query looks like
That''s not relevant! It's a permissions problem...
Mar 26, 2011 09:32 PM|Decker Dong - MSFT|LINK
Not quite be sure about what you mean：）
You'd better paste all of your sql query codes.
As far as I know, this kind of problem usually happens when your update sql query doesn't look like an Update itself. Something like this:
UPDATE CLOG SET CLOG.NEXTDUE = (
FROM CTRHIST as H1
WHERE H1.ACCT = clog.ACCT AND
H1.SEQNO = (
WHERE CTRHIST.ACCT = Clog.ACCT AND
CTRHIST.AMTPAID > 0 AND
CTRHIST.DATEPAID < CLOG.UPDATED_ON
WHERE CLOG.NEXTDUE IS NULL;
If you use this kind of codes, it will raise the error.
Because the bold statement will return a collection of data by the compiler's thinking. So it cannot be regarded as a correct statement of update statement when running.
About "How to solve the problem", please see what hans-v's suggestion：）