Received: from st-ives.alphanet.net.au (root@st-ives.alphanet.net.au [203.23.58.4]) by hub.org (8.8.8/8.7.5) with ESMTP id DAA05036 for ; Mon, 27 Jul 1998 03:54:23 -0400 (EDT) Received: from wynyard.alphanet.net.au (wynyard.alphanet.net.au [203.23.58.22]) by st-ives.alphanet.net.au (8.8.7/8.8.7) with SMTP id RAA04177 for ; Mon, 27 Jul 1998 17:54:49 +1000 Received: by wynyard.alphanet.net.au with Microsoft Mail id <01BDB987.F8FA2AF0@wynyard.alphanet.net.au>; Mon, 27 Jul 1998 17:57:08 +1000 Message-ID: <01BDB987.F8FA2AF0@wynyard.alphanet.net.au> From: Michael Yeung To: "'Interfaces of Postgres'" Subject: Problem of using Access '97 to open db Date: Mon, 27 Jul 1998 17:57:07 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable hi all,=20 I have linked the postgresql dB through ODBC Drivers from = www.insightdist.com ! Then i use Access 97 to open the database and the error says 'Error while executing query; WARN :parser : parse error at or near """ = ' I checked the log and discover that the SELECT statement with double = quote around the table name and the field name. How does it fixed with = this ? Thanks for attention and any suggestions and solutions will be highly = appreciated. regards, MICHAEL