Re: HOW DO I EDIT A RECORD IN ADO

THANK YOU!

"Brendan Reynolds" wrote:

> 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
    ... 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: ADO vs DAO (Re: Migration to SQL Backend)
    ... Ok, but, what changes do i need to make to get my odbc connection to use DAO. ... "Brendan Reynolds" wrote: ... There are certainly people who prefer ADO to DAO. ... the old argument that ADO was 'the future of data access technology' ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)