Update Query Must Use an updateable query

D

D Witherspoon

WorkLogID is Primary Key

This DOESN'T WORK! (Operation must use an updateable query)
---------------
UPDATE tblWorkLog wl1 SET DueDate = (Select Now() as field1 from tblWorkLog
wl2 where wl1.WorkLogID=wl2.WorkLogID)

This DOES WORK
-------------------
UPDATE tblWorkLog wl1 SET DueDate = Now()

The update query I am trying to write has to pull a value from another
table/query and I get the same error. For simplicity I wanted to show that
not even selecting Now() from the same table as a correlated subquery gives
me the same error.

MS Access is so irritating...
 
T

Tom Ellison

Dear D:

Access is not the culprit.

A specific portion if Access is.

That culprit is "Jet".

Access shipps with 2 databases: Jet and MSDE.

MSDE does not misbehave as you have described.

You have a choice. Use it.

Tom Ellison
 
D

D Witherspoon

That's not exactly correct. The native database backend for MS Access is
JET. Of course you can use any backend you wish and link the tables to it.
AKA. SQL Server, Oracle, or whatever.

We have used SQL Server with an MS Access Front End and have run into a
different set of problems as well.
 
Top