Sender: "Brandon Huey" <brandon@ec.asiaonline.net>
Message-ID: <37A54316.69EC9B0D@e-centric.com>
Date: Mon, 02 Aug 1999 15:04:54 +0800
From: Brandon Huey <brandon@e-centric.com>
MIME-Version: 1.0
To: mas@wellthot.com, nicolasb@maich.gr, pgsql-interfaces@hub.org
Subject: Re: [Interfaces] Read-Only ODBC, MS/ACCESS
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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