Thread: Accessing PSQL database with MS Access via ODBC
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
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 >
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 >