Re: How to get data from INFORMIX to ACCESS2.0 with ODBC?

In article <Pine.SOL.3.91.951003092411.19413A-100000@comp> "H. James Rader" <jrader@comp> writes: >On 2 Oct 1995, Karsten Rohnstock wrote: > >> >> We want to query data from INFORMIX (UNIX) with SQL to ACCESS2.0. We have a >> G+E Informix driver for ODBC, but don't know if we only have to install the >> ODBC-driver or if further programming is necessary? >> Are there any difficulties in installing of the ODBC-driver? >> >I take it that you are talking about the Q&E ODBC drivers from >Intersolv. I have spent lots of time testing those drivers and have >found that some tables cannot be updated through Access. I am still not >sure why I could not update. My understanding is that the table must have either a primary key or a unique index defined. Also, the ODBC driver must report that information correctly. (some don't) Scott