Skip site navigation (1) Skip section navigation (2)

Re: Access Linked Tables

From: Karl Swisher <kswisher(at)buffalocoal(dot)biz>
To: "Alan R(dot) Johns" <alan(at)graphicsuniversal(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access Linked Tables
Date: 2002-11-15 18:39:53
Message-ID: 5.1.0.14.0.20021115133832.00a6f9a0@mail.buffalocoal.biz (view raw or flat)
Thread:
Lists: pgsql-odbc
Thank you Alan
         That made the difference.  I had left out a space between two of 
the words in the DSN name.
Thanks
Karl
At 01:15 PM 11/15/2002 -0500, Alan R. Johns wrote:

>Are you sure you have the exact same PostgreSQL ODBC "Data Source Name"
>setup in the ODBC manager on each machine?
>
>-Alan
>
>-----Original Message-----
>From: pgsql-odbc-owner(at)postgresql(dot)org
>[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Karl Swisher
>Sent: Friday, November 15, 2002 12:35 PM
>To: pgsql-odbc(at)postgresql(dot)org
>Subject: [ODBC] Access Linked Tables
>
>
>Hello,
>         I'm having a problem with Access link tables.   I have set up an 
> .mdb file
>with links to the tables in Postgresql.  The .mdb file is on the network
>drive.   The links were made using the DSN connection from the pull down
>menu File\Get External Data\Link Tables.  I can view, update and insert
>data to the tables in the Datasheet view on my machine.   However I can't
>look at the tables when I run the .mdb file on another machine unless I
>first delete and relink the tables on that machine.  Then for the
>same  .mdb file to work on my machine I have to repeat the process.  Access
>returns an error "ODBC--connection to 'PGSQL-Buffalo Trucking' failed" and
>then "Microsoft Access can't open the table in Datasheet view".   I've
>turned on the logs in the driver but have been unable to find any generated
>log.  I've even tried (as a test) giving full public access to the tables
>in Postgresql with the same results. I've also tried using a single
>user/password in the DSN on each machine matching a user and password in
>Postgresql with the same results.
>
>         I would rather not if possible have a separate .mdb file for each 
> user
>since all the reports, forms, queries are in Access and any modification to
>them would require modifying all the files.
>
>         I have the code under HOWTOs\Access VBA on linking tables from the
>psqlODBC web site.  Should this be used instead of linking through the menus
>?
>
>         I'm using psql-ODBC 7.02.00.1, Postgresql 7.2 on the Linux 
> machine and the
>Windows client machines are all Win2k-sp2 running Office2k.
>
>Thanks
>Karl
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html



In response to

pgsql-odbc by date

Next:From: Jason TishlerDate: 2002-11-15 19:57:38
Subject: Re: [ODBC] ODBC Unix distro building woes
Previous:From: Alan R. JohnsDate: 2002-11-15 18:15:01
Subject: Re: Access Linked Tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group