From: | Brandon Huey <brandon(at)e-centric(dot)com> |
---|---|
To: | mas(at)wellthot(dot)com, nicolasb(at)maich(dot)gr, pgsql-interfaces(at)hub(dot)org |
Subject: | Re: [Interfaces] Read-Only ODBC, MS/ACCESS |
Date: | 1999-08-02 07:04:54 |
Message-ID: | 37A54316.69EC9B0D@e-centric.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)maich(dot)gr>
> To: pgsql-interfaces(at)hub(dot)org <pgsql-interfaces(at)hub(dot)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
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Pepers | 1999-08-02 08:43:13 | Ada interface? |
Previous Message | Tom Lane | 1999-08-02 04:33:12 | Re: [INTERFACES] Opening database with PGACCESS |