Be sure you do not have both DAO and ADO referenced in your project.

Also, when you open the recordset make sure that your are not limiting its
capabilities by opening it static or with a similar read only type and that
the locking strategy is correct.


James B. Byrne <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF4011F2A7C@dogbert.csillc.com...
> On 19 Apr 99, at 21:15, [log in to unmask] wrote:
>
> >
> > I have a Visual basic 6.0 program that uses ADO to access the
> > HP3000 using ODBCLink/SE version 5.56.1200.  It retrieves records
> > but I cannot update/delete/add records to the database.  I have
> > added the user to the DBE and set it up for mode 1.  When I use
> > the recordset.supports() function in VB UPDATE, DELETE, ADDNEW
> > and UPDATEBATCH all return as false.
> >
> > Is there something special that needs to be done to allow
> > updates to Image/SQL through the ODBCLink/SE driver?
> >
>
> You are most likely going throuh the Jet engine (probably 3.5 or
> 3.51) and this requires that the row have a unique index to permit
> updates.  There is a way to fake out VB to make it believe that
> this is the case.  I will try and locate a code example for you
> later this morning.
>
> Regards,
> Jim
> --
> James B. Byrne                   [log in to unmask]
> Harte & Lyne Limited             www.harte-lyne.ca
> 9 Brockley Drive
> Hamilton, Ontario                vox: +1 905 561 1241
> Canada  L8E 3c3                  fax: +1 905 561 0757
>