Re: HOW DO I EDIT A RECORD IN ADO

In addition to Val's good advice, make sure you have an editable recordset
to begin with. Unlike DAO, in ADO you get a read-only recordset if you
accept the default values for the CursorLocation, CursorType, and LockType
properties.

On-line documentation is at ...
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscadoapireference.asp

--
Brendan Reynolds (MVP)


"squiggy" <squiggy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DBB26C25-E621-435E-BAEE-3FDDBD19E131@xxxxxxxxxxxxxxxx
> 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
    ... "Brendan Reynolds" wrote: ... 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: Access performace help
    ... I move the data file to the network folder, ... Should I remove the linked tables and use DAO / ADO? ... how do I assign the record set created with ADO to the ...
    (microsoft.public.access.formscoding)
  • Re: Access performace help
    ... First thing to do is check the Access Performance FAQ Tony Toews has at ... Should I remove the linked tables and use DAO / ADO? ... how do I assign the record set created with ADO to the ...
    (microsoft.public.access.formscoding)
  • Re: Run-time error 2147217841 Query Timeout expired
    ... Depends whether he's using ADO or DAO; ... I would expect him to be using ADO. ... If you write to a field, ADO will automatically put you in Edit ... error message "Query timeout expired". ...
    (microsoft.public.vb.general.discussion)
  • 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)