Thread

Re: ODBC linked table in access on second pc

Joseph <lters@mrtc.com> — 2001-02-20T11:56:28Z

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