I do not use file DSNs, but I do used linked tables and have had need to
examine thier connection strings. To do so, go into the table's design
mode. (It will complain that it is juts a linked table and that you won't
be able to change anything... Just click OK.) Once in design mode, click on
the properties button on the design tool bar. This will open the table
properties window and the first filed will contain the loooong connection
string. Examine this to see what DSN the table was using.
HTH
"F. Michael Miller" <fm***@netzero.net> wrote in message
news:40***********************@newsreader.visi.com ...
I can't find the file dsn for an Access DB. I can refresh the tables, and
I've looked for all of the *.dsn files on the drives where it might be and
I can't seem to find it.
Is there any way to get the location of a file dsn from the linked table?
Thanks!