Paul Krikorian wrote:
>
> We currently have an IMAGE/SQL database on an HP3000 and have
> successfully attached the database from ACCESS 2.0 using HP's
> 16-bit ODBC driver. We are able to read the data with no problem,
> but receive the message "The Recordset is not updateable" when we
> try to update any of the fields. Have called HP and am awaiting
> a response, but just thought I'd ask the group if you have any
> suggestions. By the way, I wrote a test application in VB 3.0 and
> was able to update the database from it using the same ODBC connection.
HP came through quickly and got me the anwser which was that
I needed to create a unique "virtual index" from within Access.
--
Paul Krikorian | Internet: [log in to unmask]
Coast Community College District | (or [log in to unmask])
1370 Adams Ave. | Voice: (714) 438-4621
Costa Mesa, CA 92626, USA | Fax: (714) 432-5062