I lost my DSN...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • F. Michael Miller
    #1

    I lost my DSN...

    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!


    Tags: None
    • DC Fan
      #2
      Re: I lost my DSN...

      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" <fmmiv@netzero. net> wrote in message
      news:40730374$0 $17260$a1866201 @newsreader.vis i.com...[color=blue]
      > 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[/color]
      I[color=blue]
      > can't seem to find it.
      >
      >
      > Is there any way to get the location of a file dsn from the linked table?
      >
      > Thanks!
      >
      >[/color]


        Comment

        • F. Michael Miller
          #3
          Re: I lost my DSN...

          It looks like that gives me everything but the name and location of the
          actual dsn file.

          Thanks.


          "DC Fan" <grahamers.kill spamers@comcast .net> wrote in message
          news:oqednSkhbe _g-OjdRVn-hQ@comcast.com. ..[color=blue]
          > 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[/color]
          on[color=blue]
          > 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" <fmmiv@netzero. net> wrote in message
          > news:40730374$0 $17260$a1866201 @newsreader.vis i.com...[color=green]
          > > I can't find the file dsn for an Access DB. I can refresh the tables,[/color][/color]
          and[color=blue][color=green]
          > > I've looked for all of the *.dsn files on the drives where it might be[/color][/color]
          and[color=blue]
          > I[color=green]
          > > can't seem to find it.
          > >
          > >
          > > Is there any way to get the location of a file dsn from the linked[/color][/color]
          table?[color=blue][color=green]
          > >
          > > Thanks!
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • DC Fan
              #4
              Re: I lost my DSN...

              Can you publish your connection string here?


              "F. Michael Miller" <fmmiv@netzero. net> wrote in message
              news:407568b6$0 $17254$a1866201 @newsreader.vis i.com...[color=blue]
              > It looks like that gives me everything but the name and location of the
              > actual dsn file.
              >
              > Thanks.
              >
              >
              > "DC Fan" <grahamers.kill spamers@comcast .net> wrote in message
              > news:oqednSkhbe _g-OjdRVn-hQ@comcast.com. ..[color=green]
              > > 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[/color][/color]
              won't[color=blue][color=green]
              > > be able to change anything... Just click OK.) Once in design mode,[/color][/color]
              click[color=blue]
              > on[color=green]
              > > the properties button on the design tool bar. This will open the table
              > > properties window and the first filed will contain the loooong[/color][/color]
              connection[color=blue][color=green]
              > > string. Examine this to see what DSN the table was using.
              > >
              > > HTH
              > >
              > >
              > > "F. Michael Miller" <fmmiv@netzero. net> wrote in message
              > > news:40730374$0 $17260$a1866201 @newsreader.vis i.com...[color=darkred]
              > > > I can't find the file dsn for an Access DB. I can refresh the tables,[/color][/color]
              > and[color=green][color=darkred]
              > > > I've looked for all of the *.dsn files on the drives where it might be[/color][/color]
              > and[color=green]
              > > I[color=darkred]
              > > > can't seem to find it.
              > > >
              > > >
              > > > Is there any way to get the location of a file dsn from the linked[/color][/color]
              > table?[color=green][color=darkred]
              > > >
              > > > Thanks!
              > > >
              > > >[/color]
              > >
              > >[/color]
              >
              >[/color]


                Comment

                Previous template Next
                Working...