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 MAA11922 for ; Sun, 14 Jun 1998 12:01:52 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id LAA27468 for pgsql-interfaces@postgreSQL.org; Sun, 14 Jun 1998 11:42:35 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA36820; Sun, 14 Jun 1998 11:31:40 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA48512; Sun, 14 Jun 1998 11:31:40 -0400 Message-Id: <3583EB60.CEC2BDA3@insightdist.com> Date: Sun, 14 Jun 1998 11:25:20 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Matthew Cc: "'pgsql-interfaces@postgreSQL.org'" Subject: Re: [INTERFACES] MS Access can't insert with ODBC connection to PostgreSQL References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Matthew wrote: > Hello, I downloaded the latest ODBC driver for PostgreSQL from > http://www.insightdist.com/psqlodbc/ version number 06.30.0245. I got > this driver to work and show data from my database after editing the > pg_hba.conf file. However, I can't insert new records in the normal > access way. I can do these inserts when I connect to MS SQL server with > an ODBC driver in the same manner as above. Is this typical? Or do I > have something configured wrong? I unchecked both readonly checkboxes > in the ODBC config, but that had no effect. I was able to do a manual > insert query by hardcoding it. > Access must know a tables key before it will allow updates. Either make sure "Recognize Unique Indexes" is check (under Driver Options) or manually specify the key at link time. Oid may be used as a key it it is checked. In any case you must relink the table to get Access to recognize the your keys.