It’s been a while since I’ve written a Db-app from scratch and a few days ago I started writing an invoice-like app for myself.
At one point I needed to insert/update/delete into/from a resultset of a join. I was getting this error:
“Row cannot be located for updating. Some values may have been changed since it was last read.”
After googleing for a little while I found the following golden piece of information on ADO programming on the web archive which was posted here
Now everything works like a charm 🙂