It seems that the ODBC driver creates a read-only connection by default (at
least with Access). You need to turn this off as follows.
Try to create a new ODBC link from Access to PostgreSQL. When you see the
PostgreSQL Driver Setup dialog, click the Driver button in the the Options
(Advanced). This will open an Advanced Options (Driver) dialog. In this
dialog box, uncheck the ReadOnly (Default) checkbox.
I hope this solves your problem.
-Mark Schwenk
WellThot Inc.
http://wellthot.com
-----Original Message-----
From: Nicolas Boretos <nicolasb@maich.gr>
To: pgsql-interfaces@hub.org <pgsql-interfaces@hub.org>
Date: Tuesday, March 02, 1999 3:50 AM
Subject: [INTERFACES] Read-Only ODBC, MS/ACCESS
>Hello,
>
>I am experimenting with the postdrv and seems to work in Excel, but as
>read only in Acess97. Any ideas?
>Thank you,
>Nicolas Boretos
>