Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA15236 for ; Thu, 23 Jul 1998 12:22:36 -0400 (EDT) Received: from insightdist.com (ukc3to@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA22673 for pgsql-general@postgreSQL.org; Thu, 23 Jul 1998 12:01:34 -0400 (EDT) X-Authentication-Warning: u1.abs.net: ukc3to set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA26894; Thu, 23 Jul 1998 11:57:09 -0400 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA75504; Thu, 23 Jul 1998 11:57:08 -0400 Message-Id: <35B75D5C.63B6219A@insightdist.com> Date: Thu, 23 Jul 1998 11:57:16 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Bruce Tong Cc: PostgreSQL General , pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ODBC Driver References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bruce Tong wrote: > > Installed, threw away the old data link, created a new data link, same > problem occurred. > OK, could you try this before we resort to more drastic things. When you are looking at the design view of your query, right click and call up "properties" or call it up under the "View" menu. For the "RecordSet type" property, try changing it to "Snapshot". See if this causes Access to not throw the "order by" clause in the query. Of course having the recordset type as a snapshot means you can't update the query resultset. Let me know if it works. Byron