Обсуждение: Access Linked Tables

Поиск
Список
Период
Сортировка

Access Linked Tables

От
Karl Swisher
Дата:
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



Re: Access Linked Tables

От
"Alan R. Johns"
Дата:
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@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of Karl Swisher
Sent: Friday, November 15, 2002 12:35 PM
To: pgsql-odbc@postgresql.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


Re: Access Linked Tables

От
Karl Swisher
Дата:
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@postgresql.org
>[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of Karl Swisher
>Sent: Friday, November 15, 2002 12:35 PM
>To: pgsql-odbc@postgresql.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