Non-Updateable Query

[swalsh84]

I searched quite a bit and went through the normal answers of securities and permissions. I still cannot make this query work. It's simple and was working one day, and then a few days ago it broke. Nothing significant has changed since then. I have tried recreating the query from scratch (all on field of it), but still to no avail.



Any thoughts?

UPDATE tbl_ERC_Cases INNER JOIN dbo_INV ON tbl_ERC_Cases.InvestorCode = dbo_INV.INV SET tbl_ERC_Cases.InvestorName = dbo_INV!INVESTOR;

[orange]

You could try (untested)

UPDATE T
SET T.InvestorName = X.INVESTOR
FROM tbl_ERC_Cases T INNER JOIN dbo_INV X
ON T.InvestorCode = X.INV

[swalsh84]

I'm not quite sure what you're doing here... It looks like there are some other tables involved than the two I have listed.

Is that the case?

[orange]

No, there are no new tables. I have used aliases on your tables and adjusted the syntax a little. I did change your ! to a . in one place.

What has changed since the query worked?
Have you seen this by Allen Browne?
http://allenbrowne.com/subquery-02.html

[swalsh84]

I had not seen that by Allen Browne, but I did review the info and this not a subquery. I have no idea what changed. It's a simple query to pull one field from one table and put it on another matching on the common field from both. Access makes me angry sometimes when it overthinks itself...

OK. Narrowed it down a bit more. The query runs just fine in the production version, but not in the development version. Any thoughts on where to start pulling things apart to identify the differences?

What's even more interesting is that when I recreate the query in the dev version, it throws the same error. I tried repairing the MDB file with no changes.

Not sure what's going on with that MDB file, but I exported the single query to the production version and it ran just fine... Sigh...