pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRead-Only ODBC, MS/ACCESS
3+ messages / 3 participants
[nested] [flat]
* Read-Only ODBC, MS/ACCESS
@ 1999-03-02 09:59 Nicolas Boretos <nicolasb@maich.gr>
0 siblings, 0 replies; 3+ messages in thread
From: Nicolas Boretos @ 1999-03-02 09:59 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Read-Only ODBC, MS/ACCESS
@ 1999-03-02 13:04 Mark A. Schwenk <mas@wellthot.com>
0 siblings, 0 replies; 3+ messages in thread
From: Mark A. Schwenk @ 1999-03-02 13:04 UTC (permalink / raw)
To: nicolasb@maich.gr; pgsql-interfaces@hub.org
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [Interfaces] Read-Only ODBC, MS/ACCESS
@ 1999-08-02 07:04 Brandon Huey <brandon@e-centric.com>
0 siblings, 0 replies; 3+ messages in thread
From: Brandon Huey @ 1999-08-02 07:04 UTC (permalink / raw)
To: mas@wellthot.com; nicolasb@maich.gr; pgsql-interfaces@hub.org
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
> >
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-08-02 07:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-02 09:59 Read-Only ODBC, MS/ACCESS Nicolas Boretos <nicolasb@maich.gr>
1999-03-02 13:04 Re: [INTERFACES] Read-Only ODBC, MS/ACCESS Mark A. Schwenk <mas@wellthot.com>
1999-08-02 07:04 Re: [Interfaces] Read-Only ODBC, MS/ACCESS Brandon Huey <brandon@e-centric.com>
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