Re: [INTERFACES] Re: Insight ODBC driver

The Hermit Hacker wrote:

> Please note that postodbc-users@listserv.direct.net is no longer
> considered the *official* support channel for the ODBC driver...
>
> Reposting to pgsql-interfaces@postgresql.org
>
> On Thu, 16 Apr 1998, Olaf Mittelstaedt wrote:
>
> > Hello all,
> >
> > after installation of PostgreSQL 6.3.1 and the newest Insight ODBC
> > driver there's only one problem left: when using Access 2.0 (or MS
> > Query 1.0) on a Windows NT 4.0 system all tables are read only, even
> > if a unique index is present.
> >

1.  I am not as familiar with Access 2.0.   But the 7.0 and 97 versions
require a unique key to be specified at link time for an update to be
allowed.   I want to be sure that you have done that, and that you not
referring to the "create unique index" statement which creates the index
in the database table on the server.

2. There is a read-only check box on the data source setup dialog.   This
was put in to prevent unintentional key strokes from getting into the
database. This is remarkably easy to do in MS Access.   Just unchecked the
box for your data source.