Re: [Interfaces] Read-Only ODBC, MS/ACCESS

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