Re: MS ACCESS <-> DSA

Joe Lumbley wrote: > > How about a quick pointer to something I remember seeing here? > altavista and iiug searches don't find this. > > Someone wrote about & solved a problem about connecting MSACCESS to 7.xx. > Problem was a problem with inserts/updates (I believe). The answer had > to do with the need to have a unique index on the tables. At the time > I saw it I wasn't interested in Access...now one of my cohorts has a > similar problem and I'd appreciate a pointer to the original article thread. > TIA. > > Joe > -- > --------------------------------------------------------------------------- > Joe Lumbley(jlumbley@netcom.com) > --------------------------------------------------------------------------- Joe, We have just had this problem attaching an Informix Table (V7.13) to an MS-Access database and inserting/updating/deleting rows. In the Access Manual (somewhere) we found that a unique index is required by Access in order for it to allow insert/delete/update activity against the external table. We created the unique index and this worked, unfortunately we now have problems with ODBC or EDA which is failing the insert/update/delete. Access reports this as an ODBC error, and examination of the Informix Logical Logs shows that the update is being logged, but then a ROLLBACK is issued. At the moment we do not know if MS-Access, ODBC or EDA is rolling the transaction back. Hope this helps, -- Rick Ward Senior DBA Great Universal Stores Home Shopping MANCHESTER, UK