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 PAA02645 for ; Thu, 16 Apr 1998 15:07:48 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.8.5/8.8.5) with UUCP id OAA17745 for pgsql-interfaces@hub.org; Thu, 16 Apr 1998 14:59:56 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA35939; Thu, 16 Apr 1998 14:55:09 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA59414; Thu, 16 Apr 1998 14:51:31 -0400 Message-Id: <353652BC.C5474A4D@insightdist.com> Date: Thu, 16 Apr 1998 14:49:32 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: pgsql-interfaces@hub.org, mittelstaedt@fh-ulm.de Cc: postodbc-users@listserv.direct.net, pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Re: Insight ODBC driver References: Content-Type: multipart/mixed; boundary="------------36435D8AF468BB33CA7D238B" This is a multi-part message in MIME format. --------------36435D8AF468BB33CA7D238B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --------------36435D8AF468BB33CA7D238B Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David Hartwig Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: David Hartwig n: Hartwig;David email;internet: daveh@insightdist.com x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------36435D8AF468BB33CA7D238B--