Received: from synapse.sri.com (synapse.SRI.COM [128.18.20.155]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA20437 for ; Mon, 13 Dec 1999 11:54:20 -0500 (EST) (envelope-from lim@nki.rfmh.org) Received: from [206.197.22.97] (x.rfmh.org [206.197.22.97]) by synapse.sri.com (8.8.8+Sun/8.8.3) with SMTP id IAA09515 for ; Mon, 13 Dec 1999 08:55:57 -0800 (PST) Message-ID: <38552779.F8763D73@nki.rfmh.org> Received: from LIMNT by [206.197.22.97] via smtpd (for synapse.SRI.COM [128.18.20.155]) with SMTP; 13 Dec 1999 16:52:57 UT Date: Mon, 13 Dec 1999 12:06:01 -0500 From: "Kelvin O. Lim" X-Mailer: Mozilla 4.7 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: access97-Recordset not updatable Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am using the current psqlodbc driver (6.40.0007) with Access97 to communicate with a Postgresql server (6.5.3) running on a Solaris platform. The Postgres server has been working fine; I have a php/apache application which has been working smoothly. I can create the DSN on my windows98 machine and have configure the driver so that all read-only options are NOT selected. Using Access97, I have no problem viewing table data from the Postgres server, but whenever I try to modify an entry, I get the error: This Recordset is not updatable. Any pointers about what I may be doing wrong would be greatly appreciated. Thanks, Kelvin Lim