Thread: Accessing PSQL database with MS Access via ODBC

Accessing PSQL database with MS Access via ODBC

From
"Guy Corbaz"
Date:
Hello,

I'm using Postgres 7.0 under SuSE Linux 7.0. I installed ODBC 6.50.00.00
drivers on my PC, and added a data source. I can access the tables from MS
Access, but in "read only" mode. I tied several options in the ODBC drivers,
but without any success.

Does anyone have an idea about how solving this problem ?

Best regards, Guy Corbaz


Re: Accessing PSQL database with MS Access via ODBC

From
"Diego A. Puertas F."
Date:
Follow this path:

Control Panel - ODBC - <select your DSN> - Configure -
Data Source - Uncheck "Read only"

Good luck!


El 13/12/00, Guy Corbaz escribió:

> Hello,
>
> I'm using Postgres 7.0 under SuSE Linux 7.0. I installed ODBC 6.50.00.00
> drivers on my PC, and added a data source. I can access the tables from MS
> Access, but in "read only" mode. I tied several options in the ODBC drivers,
> but without any success.
>
> Does anyone have an idea about how solving this problem ?
>
> Best regards, Guy Corbaz
>



Re: Accessing PSQL database with MS Access via ODBC

From
Date:
Also, you may need to relink your tables after you change the ODBC options.

----- Original Message -----
From: Diego A. Puertas F. <dpuertas@uc.edu.ve>
To: Guy Corbaz <guy.corbaz@swissmail.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, December 14, 2000 3:22 PM
Subject: Re: [NOVICE] Accessing PSQL database with MS Access via ODBC


Follow this path:

Control Panel - ODBC - <select your DSN> - Configure -
Data Source - Uncheck "Read only"

Good luck!


El 13/12/00, Guy Corbaz escribió:

> Hello,
>
> I'm using Postgres 7.0 under SuSE Linux 7.0. I installed ODBC 6.50.00.00
> drivers on my PC, and added a data source. I can access the tables from MS
> Access, but in "read only" mode. I tied several options in the ODBC
drivers,
> but without any success.
>
> Does anyone have an idea about how solving this problem ?
>
> Best regards, Guy Corbaz
>