Re: ODBC Driver

Diana Vidal <vidald@fonorola.com> writes: > I have been using the "Openlink" ODBC driver to link my Informix 7 database > to my Ms Access database (running on Windows 3.11). <snip> > My problem comes when I try to update a field on the database. When I try to do > that, the database gives me the error: "The field is not updatable". I cannot > enter new data or change the existing records ( and to me, not being able > to update the records or enter new records defeats the purpose of having an > ODBC driver) > > I haven't been able to find where the problem resides (would it be an MS ACCESS > problem, an Informix problem or the ODBC driver problem?) The "problem" very likely is with Access. Access requires a unique index on any table you wish to update. Once you create the index, drop the attachment in Access and re-attach. At that point you shoould be abel to update. I have used OpenLink with Access & Informix. If you have unique indexes, inserts updates and deletes should all work fine. Irwin Goldstein Objective Software Systems, Inc.