From: Joel Burton <jburton@scw.org>
To: diffs@vsnl.com
Cc: pgsql-general@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: RE: Postgres connect with Access
Date: Tue, 1 Aug 2000 17:07:49 -0400
Message-ID: <398703E5.10395.47F9ACE@localhost> (raw)
> Re: Read-only tables/recordsets in Access
(1) Have you tried using psql on the Win32 machine? This will let us
know
whether your permissions are correct for editing from the other
machine.
(2) Have you tried using another ODBC client (such as MS Query)?
This will let us know whether its Access v ODBC.
(3) Are you sure that Access is properly recognizing your primary
key? (check the table design if unsure.) No primary key = No
updating of records.
(4) Do you have the READ ONLY option in the ODBC data source
turned off? The default is to leave it on. Check in *both* places in
the data source. (If you examine the table properties for the linked
table, you can see the Connect string, which will show READONLY=0
or 1 for this setting.)
--
There is a draft of a FAQ for PostgreSQL + Access at
www.scw.org/pgaccess. This may be helpful for other questions.
P.S. This question is better suited for the psql-interface mailing list,
which covers ODBC and other interfaces.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
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: jburton@scw.org, diffs@vsnl.com, pgsql-general@postgreSQL.org
Subject: RE: Postgres connect with Access
In-Reply-To: <398703E5.10395.47F9ACE@localhost>
* 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