Re: MSAccess and Informix

Karmen, Your problem seems to be related to the default Recordset Type in MS-Access, which is Dynaset. This requires indices on the sort fields (too complicated to explain here). To fix this, bring up the Query properties dialog box and change the Recordset Type to Snapshot. Access will then retrieve the records and sort them OK, but you won't be able to make interactive changes to the data retrieved. I've been amazed by the number of times I have been caught out by this. My standard way of dealing with it is to ALWAYS create the Query as a Snapshot and change it whenever I need the interactive update capability. HTH, Rick. Karmen.Karlusic@hfp.hr on 10/03/99 07:58:13 PM Please respond to Karmen.Karlusic@hfp.hr To: informix-list@iiug.org cc: (bcc: Rick Pearson/JMJ/AU) Subject: MSAccess and Informix Hello All, We have Informix OnLine 7.22.UC1 and Sun Solaris 2.5 on server side, and Informix CLI 2.50.TC2, WIN95, MSAccess (Office97) on client side. Tables from Informix database are linked into MSAccess application. How to do ORDER BY informix_table_name.column_name on linked table when informix_table_name.column_name don't have unique index. There is no problem when we have unique index on informix_table_name.column_name, but we get ODBC call failed in other casses. Thanks in advance, Karmen