Thread

1. ODBC linked table in access on second pc

   Carsten Huettl <chuettl@ahorn-net.de> — 2001-02-16T16:19:42Z

   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
   
   

2. Re: ODBC linked table in access on second pc

   Stefan Waidele jun. <st.waidele.jun@krone-neuenburg.de> — 2001-02-20T09:03:18Z

   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