pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Read-only in MSAccess
3+ messages / 3 participants
[nested] [flat]
* Re: Read-only in MSAccess
@ 1999-03-08 21:46 Ben Gunter <bgunter@alef.gcsu.edu>
1999-03-08 22:04 ` Re: [INTERFACES] Re: Read-only in MSAccess Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Ben Gunter @ 1999-03-08 21:46 UTC (permalink / raw)
To: pgsql-interfaces
(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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Re: Read-only in MSAccess
1999-03-08 21:46 Re: Read-only in MSAccess Ben Gunter <bgunter@alef.gcsu.edu>
@ 1999-03-08 22:04 ` Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Ross J. Reedstrom @ 1999-03-08 22:04 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] Re: Read-only in MSAccess
@ 1999-03-08 22:10 Michael Davis <michael.davis@prevuenet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Davis @ 1999-03-08 22:10 UTC (permalink / raw)
To: pgsql-interfaces
I did some brief testing with Access97, the log files did not show any
references to "primary" nor "foreign". I would to know if it is possible to
get Access to ask the server what the primary keys are? I know there is an
ODBC function call that an application can use to see what functionality the
driver supports. I wonder how this called is being handled in the postgres
ODBC driver? I am sure I will be doing a lot more testing on this in the
near future.
-----Original Message-----
From: Ross J. Reedstrom [SMTP:reedstrm@rice.edu]
Sent: Monday, March 08, 1999 3:05 PM
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Re: Read-only in MSAccess
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-03-08 22:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-08 21:46 Re: Read-only in MSAccess Ben Gunter <bgunter@alef.gcsu.edu>
1999-03-08 22:04 ` Ross J. Reedstrom <reedstrm@rice.edu>
1999-03-08 22:10 RE: [INTERFACES] Re: Read-only in MSAccess Michael Davis <michael.davis@prevuenet.com>
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