Received: from mtiwmhc01.worldnet.att.net (mtiwmhc01.worldnet.att.net [204.127.131.36]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA28203 for ; Sun, 9 Aug 1998 14:48:02 -0400 (EDT) Received: from taral ([12.67.83.14]) by mtiwmhc01.worldnet.att.net (InterMail v03.02.03 118 118 102) with SMTP id <19980809184731.IMCA17774@taral> for ; Sun, 9 Aug 1998 18:47:31 +0000 From: "Taral" To: Subject: MS Access via ODBC Date: Sun, 9 Aug 1998 13:47:30 -0500 Message-ID: <000001bdc3c6$299f7960$3b291f0a@taral> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I noticed that when trying to get MS Access to do a query of "SELECT * FROM table ORDER BY somekey" as its data source for a form, it actually issues "SELECT primarykey FROM table ORDER BY somekey", which PostgreSQL rejects because "somekey" isn't being selected. Now, either PostgreSQL has put an (odd) restriction on SQL, or MS Access is issuing an invalid SQL query. Which one is it? Taral