From: Brandon Huey <brandon@e-centric.com>
To: mas@wellthot.com
To: nicolasb@maich.gr
To: pgsql-interfaces@hub.org
Subject: Re: [Interfaces] Read-Only ODBC, MS/ACCESS
Date: Mon, 02 Aug 1999 15:04:54 +0800
Message-ID: <37A54316.69EC9B0D@e-centric.com> (raw)
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
> >
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: brandon@e-centric.com, mas@wellthot.com, nicolasb@maich.gr, pgsql-interfaces@hub.org
Subject: Re: [Interfaces] Read-Only ODBC, MS/ACCESS
In-Reply-To: <37A54316.69EC9B0D@e-centric.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox