Re: MS Access / Informix connection is read-only

Posted in 1998

Jay Aymond — Wed, 01 Apr 1998 18:29:36 GMT — source: Informix-list mailing list archive (1991-1998)

hwittenb@pacbell.net (Howard Wittenberg) wrote: >In article <6fph7d$nf5@bgtnsc03.worldnet.att.net>, jay@ulife.com says... > >>ODBC requires that a table have a unique key if it is going to be updatable. >Be >>sure that you have either Primary Keys or Unique Indexes defined for any table >>that will be updatable from MS Access. >> > >Thanks for the posting. I wish that was it. We have a number of tables and >they all have Primary Keys. > >Howard > Have you tried Unique Indexes instead of Primary Keys. I think I remember reading somewhere that some ODBC drivers do not recognize the Primary Key attribute. *************************************************************** Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com ***************************************************************