Re: MS Access / Informix connection is read-only

>> >> 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 tab= les 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 >> *************************************************************** >> If the table have unique index then scrolling attached tabel(s) ) is very= slow. This problem is with the Informix 7.2. Why? What do? Thanks Rein Puksand email:rpuksand@epbe.ee Rein Puksand Bank of Estonia Phone:(372) 631 0886 Fax.(372) 631 0899 e-mail:rpuksand@epbe.ee