Informix ODBC driver cant access ANSI database

Hi all, I am trying to access an ANSI compliant Informix database from Access 97. Version Info: Informix ODBC driver 3.30, ODBC Driver Manager 3.0. Platform NT and 98. From Access, the tables can be successfully linked using ODBC. One can see the table definitions in Access. Only when you try to view the table data, the following error message is given 'Can't find attached or linked table, the specified table <tablename> is not in database (#-206)' The table is very much present in the database. One more thing, the ODBC driver is able to link and display data from the sample database provided by Informix. This sample database in non- ANSI. To confirm that this probably an ANSI related issue, I created a non-ANSI copy of our database and the ODBC connection worked! So, what should be done to get the ODBC connection working with an ANSI compliant Informix database? Thanks for your time. Di Sent via Deja.com http://www.deja.com/ Before you buy.