MS ACCESS ODBC ERROR with Informix column type MONEY

Posted in 1996

Konrad Smuts — 6 Nov 1996 12:31:57 GMT — source: Informix-list mailing list archive (1991-1998)

MS ACCESS gives me an ODBC error whenever I try to view a column of type money from an Informix database table that was attached using Openlink ODBC driver. When I view the same column with MS Query it seems to work fine. The problem seems to lie within MS Access. Does anybody know of an solution of how to view columns of Informix type Money from within MSAccess. I am using a Openlink version 1.10 16bit ODBC driver. with MSAccess version 2.0 to connect to Informix Version 7.20.UC2. Regards Konrad Smuts email: smutsk@sentech.co.za