RE: MSAccess and Informix

Posted in 1999

Rein Puksand — Thu, 11 Mar 1999 11:23:40 +0200 — source: Informix-list mailing list archive (1991-1998)

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Karmen Sent: 10. m'rts 1999. A. 11:58 To: informix-list@iiug.org 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 Bring up Query properties dialog box. Change Design View to SQL View. And after Select type: top 100 percent. Select top 100 percent .......... FROM ................. ORDER BY ............ rpuksand@epbe.ee