RE: Postgres connect with Access

> 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(at)scw(dot)org
Support Center of Washington (www.scw.org)