From: Mark A. Schwenk <mas@wellthot.com>
To: nicolasb@maich.gr
To: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Read-Only ODBC, MS/ACCESS
Date: Tue, 2 Mar 1999 07:04:44 -0600
Message-ID: <02e601be64ad$50572200$1302a8c0@daffy.wellthot.com> (raw)
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: mas@wellthot.com, nicolasb@maich.gr, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Read-Only ODBC, MS/ACCESS
In-Reply-To: <02e601be64ad$50572200$1302a8c0@daffy.wellthot.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