Обсуждение: 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
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
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