Message-Id: <35841D2D.7EEFC440@insightdist.com>
Date: Sun, 14 Jun 1998 14:57:50 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: Matthew <matt@ctlno.com>
Cc: "'pgsql-interfaces@postgreSQL.org'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access can't insert with ODBC connection to
	PostgreSQL
References: <A043233669F9D111B99700A0C92376CA151E@srv.ctlno.com>
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.
>

In addition to the datasource not being read-only, Access requires a unique
identifier to be able to update any records.  The driver, by default, does
not report unique identifiers automatically.  Either you must enable the
"recognize unique indexes" advanced driver option OR, if you are using
Access 95 or 97, you can manually select the unique identifier while linking
the table.

Hope that helps.

Byron