Re: Access bug on Update queries
Oddly enough, I wonder if this bug is related to something else that has sometimes shown up in this forum, and that in fact happened to me once.
The workaround for the bug is to make a single-table query that takes in the whole table (i.e. SELECT * FROM table), then work through that rather than directly updating the table. When I was building some forms bound to back-end tables, I would get a dialog box asking where Access could find the tables even though I had used Linked Table Manager to build the linkages. But when I created the single-table queries and bound the forms to the queries, it went silent and never again asked me where to find the record sources.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.