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