Update on Access?
Posted on 2012-03-12
I'm trying to do an update on access, but I keep getting "Operation must use an updateable query"
I have full access to the table that I'm trying to do updates on, and on some REAL simple updates, it seems to go through.
Basically I have a table A that contains client info (name, etc.. and also updateuser, updatedate)
Table B contains the clientname, updateuser, rundate
I first try to find the latest run dates of each clients so I have a query called C:
FROM B as a, (SELECT clientname, max(rundate) as latest_date FROM B GROUP BY clientname) as F
WHERE a.clientName = F.clientName and a.rundate = f.latest_date
So basically I'm just trying to update the table to include the latest user and the date...
I believe the issue has to do with me trying to update from a query that includes grouping... Any idea how to get around this? Thanks!
I want to update the