Error on update of recordset (1 Viewer)

[JohnPapa]

All of a sudden (and after a Windows update) I get the following error when I try to Update.
Otherwise the program works fine.
I use Access 365 and SQl Express

The Windows update info is

Will try to uninstall Windows update.

BTW, I deleted the table tblSerial and recreated it.

 

[Ranman256]

if the odbc is working
if the recordset is dynaset
then:

with rstSerial
  .edit
  .strL = "02"
  .update
end with

 

[JohnPapa]

I removed the Windows update and it works fine.

I will try to reinstall the Windows update and see if it was a transient problem.

 

[The_Doc_Man]

I'm with Ranman256... you are supposed to tell the recordset you want to edit it first with .Edit (or create a new record with .AddNew) before you would be allowed to update the record. I suppose there are exceptions - but I also see it as possible that the Windows Update corrected an erroneous behavior.

 

[JohnPapa]

I noted the comment on "Edit".

I just checked and it works with the Windows update. Maybe it was the restart that fixed the problem.

 

[KitaYama]

I'm with Ranman256... you are supposed to tell the recordset you want to edit it first with .Edit

Doc OP's recordset is ADODB not DAO.
To best of my knowledge ADODB recordset doesn't need .Edit nor has such a method.
But you need to set the cursor location to client to be able to update a record.
rs.CursorLocation = adUseClient

 

[The_Doc_Man]

Whoopsie! Some times I notice things like that. Sometimes, not so much. Apologies for my confusion.

 

[KitaYama]

Some times I notice things like that. Sometimes, not so much.

No worries. All of us have one of those hard days.