just "read only" tables in MS-Access via ODBC - Mailing list pgsql-odbc

From Thomas M. Parris
Subject just "read only" tables in MS-Access via ODBC
Date
Msg-id ABEMIBBGEEMDKKLMMPHLOEELHBAB.parris@isciences.com
Whole thread Raw
Responses Re: just "read only" tables in MS-Access via ODBC
List pgsql-odbc
Configuration:

  postgresql server: Redhat 7.2/PGSQL 7.1.3
  windows odbc driver: psqlodbc-7.02.0005
  odbc client: MS-Access 2000/Windows 2000

Problem:

  After linking to an ODBC table in access, I only get 'read only' access to
by table.

What I have done:

  1. Verified the user has read/write access to tables.
      a. by using psql on the Redhat server to peform selects and inserts.
    b. by using psql (cygwin) on Windows client to peform selects and inserts.

  2. Verified the odbc dsn was not set up with 'read only' boxes checked
(both places)

  3. Scanned the FAQs and the mailing list archives.  I see some related
discussion, but
     nothing describing a solution that seemed relevent.

I must be doing something truly stupid and easily overlooked.  Can someone
help?

Many thanks in advance,
Tom Parris

------------------------------------------------------
Thomas M. Parris
Research Scientist & Executive Director, Boston Office
ISCIENCES, LLC
685 Centre Street, Suite 207
Jamaica Plain, MA  02130
voice: 617.524.8041          http://www.isciences.com/
fax:   509.463.4679          http://www.terraviva.net/
email: parris@isciences.com
------------------------------------------------------


pgsql-odbc by date:

Previous
From: Chris Gamache
Date:
Subject: Re: problem with add
Next
From: "Thomas M. Parris"
Date:
Subject: Re: just "read only" tables in MS-Access via ODBC