Re: ODBC / Access 97 front end for Informix 7.22.TC2

Posted in 1997

Chris Drauch — 31 May 1997 08:48:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Sky Southwell wrote > >We are getting an ODBC Error #3146 with our application. We have been able >to select and insert, but we cannot update. > >Has anyone encountered this error? Do we have a problem with our ODBC >settings, or is there a problem with our ODBCDirect string?: > >Set RS = consPubs.OpenRecordSet("select * from Authors where LastName = >'Smith',dbOpenDynamic, 0, dbOptimistic) Just a wild guess: Access needs an unique key on update tables. BTW: Which ODBC? Online or SE? Layout of your tables? Ciao, -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...