Horton

Thread

  1. Accessing PSQL database with MS Access via ODBC

    Guy Corbaz <guy.corbaz@swissmail.com> — 2000-12-13T21:59:06Z

    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

  2. Re: Accessing PSQL database with MS Access via ODBC

    Diego A. Puertas F. <dpuertas@uc.edu.ve> — 2000-12-14T21:22:42Z

    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
>

  3. Re: Accessing PSQL database with MS Access via ODBC

    davidb@vectormath.com — 2000-12-14T23:52:47Z

    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
>