Re: MS Access / Informix connection is read-only

Howard Wittenberg wrote: > > 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 Then(if the table have a unique index) scrolling attached( to Informix 7,2) tabels are very slow. Why? Help? Rein Puksand