HOW DO I EDIT A RECORD IN ADO

PREVIOUSLY, IN DAO I USED CODE SIMILAR TO THIS:

With rst
.Edit
![Pro Work] = "Yes"
![Work Date] = Date
![Status] = "App Not in Work Que"
.Update
End with

How do I edit the same record set using ADO? I have read a few manuals, but
found them a little confusing. My time limits my search on the internet.

I have my connection established and I am able to read data in from my
record set
but when my program decisions through the logic it doesn't edit the record
set.

.

Relevant Pages

  • Re: HOW DO I EDIT A RECORD IN ADO
    ... Unlike DAO, in ADO you get a read-only recordset if you ... > How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)
  • RE: HOW DO I EDIT A RECORD IN ADO
    ... IN DAO I USED CODE SIMILAR TO THIS: ... > With rst ... > How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)
  • RE: .Update
    ... I have not gotten to the .edit problem yet. ... >In your code you I think you need to set the record set ... >> value is changed to No for this item in tbl2 with no ...
    (microsoft.public.access.formscoding)
  • .update
    ... I have not gotten to the .edit problem yet. ... >In your code you I think you need to set the record set ... >> value is changed to No for this item in tbl2 with no ...
    (microsoft.public.access.formscoding)
  • Re: HOW DO I EDIT A RECORD IN ADO
    ... IN DAO I USED CODE SIMILAR TO THIS: ... > With rst ... > How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)