Re: MS Access / Informix connection is read-only

In article <35228783.181876144@news.eatel.net>, jay@ulife.com says... > >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. > > Thanks for the thought(s). I believe we have the problem solved. It was with the keys... Apparently the owner of the keys wasn't the same as the tables and the drivers wouldn't recognize the keys. Anyway, they say they are fixing the problem and we should be able to reattach the tables and they will be OK. This wasn't a problem with the 16-bit Visigenic drivers. The Unique Indexes would have been a work-around for the problem. When you attach the table(s), Access asks you to specify the Unique Index field and if you select a field, then the table is also updatable. Howard