hello.
i found the below suggestion after having tried it myself with no
success.
using ms query i was able to update the postgres database, but from
access i am still paralysed by a read-only connection. has anyone
discovered a solution?
thanks, -brandon
> 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
> >
>