Thread: ODBC linked table in access on second pc
Hello, I have a pgsql db (v.6.5.3) with some tables. On my pc1 I have created a MS access front end (with ODBC) with these tables linked. When I start the MS access front end from my pc2 (same ODBC driver/setup) I get access denied while trying to open the linked tables. I can link the tables again from pc2 and open them within the same front end. This let me open the tables on pc2 but not on pc1. There only works the first links. In summary: The links I created (in the same Access front end) works only on the pc where they have been created. Where am I wrong? How can I correct this behaviour? TIA C. -- Carsten Huettl - <http://www.ahorn-Net.de> pgp-key on request
I can backup this report. At 18:19 16.02.2001 +0200, Carsten Huettl wrote: >I have a pgsql db (v.6.5.3) with some tables. same here >On my pc1 I have created a MS access front end (with ODBC) with >these >tables linked. >When I start the MS access front end from my pc2 (same ODBC >driver/setup) I get access denied while trying to open the linked >tables. I can link the tables again from pc2 and open them within the >same front end. >This let me open the tables on pc2 but not on pc1. There only works >the first links. I was using Delphi 5.0, ODBC, Pg Worked fine on one PC, didn't work on another with the same settings. Stefan
I would turn on logging on your server and see what user name postgres is getting/seeing. Is access sending a username from the 'CurrentUser' function, or are you storing the username in the link information. I have trouble with Access 2000 wanting to store the username in the connection. I don't like that because I want access to use the 'CurrentUser' variable as the user name for the postgres connections. Joseph Showalter -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Stefan Waidele jun. Sent: Tuesday, February 20, 2001 4:03 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] Re: ODBC linked table in access on second pc I can backup this report. At 18:19 16.02.2001 +0200, Carsten Huettl wrote: >I have a pgsql db (v.6.5.3) with some tables. same here >On my pc1 I have created a MS access front end (with ODBC) with >these >tables linked. >When I start the MS access front end from my pc2 (same ODBC >driver/setup) I get access denied while trying to open the linked >tables. I can link the tables again from pc2 and open them within the >same front end. >This let me open the tables on pc2 but not on pc1. There only works >the first links. I was using Delphi 5.0, ODBC, Pg Worked fine on one PC, didn't work on another with the same settings. Stefan