From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Re: Read-only in MSAccess
Date: Mon, 08 Mar 1999 16:04:37 -0600
Message-ID: <36E44975.1379348E@rice.edu> (raw)
References: <99030816523400.00644@schwa>
I've noticed this affect. Has anyone run traces of the connection, to
see if Access tries to determine the primary key from the backend? Does
this requirement go away if you (manually) set the 'relhaspkey' bool in
pg_class for the table? I'd do all this testing myself, but my NT test
box got taken away (yeay! boo! I'm so conflicted...)
Ross
Ben Gunter wrote:
>
> (Original message was lost. Oops.)
>
> I was fiddling around with Access and the ODBC driver this morning and
> discovered that Access will not allow you update ODBC sources unless you pick
> at least one field (up to ten) as a unique index. Otherwise, it's read-only.
>
> Hope this helps.
>
> -Ben
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@rice.edu
Subject: Re: [INTERFACES] Re: Read-only in MSAccess
In-Reply-To: <36E44975.1379348E@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox