From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: diffs@vsnl.com
Date: Tue, 1 Aug 2000 17:07:49 -0400
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: RE: Postgres connect with Access
CC: pgsql-general@postgreSQL.org, pgsql-interfaces@postgreSQL.org
Message-ID: <398703E5.10395.47F9ACE@localhost>

> 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)