just "read only" tables in MS-Access via ODBC

From: "Thomas M(dot) Parris" <parris(at)isciences(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: just "read only" tables in MS-Access via ODBC
Date: 2003-04-01 22:05:31
Message-ID: ABEMIBBGEEMDKKLMMPHLOEELHBAB.parris@isciences.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)isciences(dot)com
------------------------------------------------------

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Thomas M. Parris 2003-04-01 22:14:47 Re: just "read only" tables in MS-Access via ODBC
Previous Message Chris Gamache 2003-04-01 20:03:47 Re: problem with add