Recordset.update Not Working on Certain Queries

[leishtheman15]

Hi

I encounter a VBA error when trying to use the recordset.edit recordset.update combo on some recordsets. I was hoping somebody could explain why it works on some and not others?

The SQL queries behind the recordsets tend to be simpler when the above works, e.g. they will typically be retriving data from 1 table only. If the SQL contains joins, this is when I tend to experience difficulties.

Of course, I could just use SQL UPDATE query, but I'd like to understand the above in any instance for reference. I've tried Googling it but couldn't find an answer, can anybody help?

Many thanks,
Andy

 

[Micron]

Always post the error number and message. Since different queries are involved from time to time, it could be practically anything from where I sit. If you can't turn a copy of the select query into an update that will not choke when you try to go to datasheet view (i.e. without running it), then I suspect the select query recordset is not updatable. For that I'd suspect defined relationships could be the issue - you are trying to update the "many side" only.

 

[xenou]

See here for many details:
Roger's Access Blog: This Recordset Is Not Updateable. Why?

Sometimes also common problem is you are using grouping.