I lost my DSN...

[fmm]

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!

 

[FoFa]

Search your registery, or try \program files\common files\odbc\data sources

 

[fmm]

I know it's not on my machine, because other users on the network can access the DB when my machine is lost.

I was hoping there was a way to derive the location from inside of Access, but I don't think that's possible.

 

[FoFa]

If it was not setup as a file DSN, and sometimes as a file DSN depending on the version of windows, there might be a registry entry containing the DSN information

 

[fmm]

Thanks for the reply.

You noted:
If it was not setup as a file DSN, and sometimes as a file DSN depending on the version of windows, there might be a registry entry containing the DSN information

It was;
That's never happened before, but I will look.

 

[FoFa]

Depending on the type of ODBC connection, you can turn on system objects in your access DB, check in MSysObjects table under NAME column, then check to see what the CONNECT column says.

 

[fmm]

It looks like I get everything except the name & location of the actual DSN file.

Thanks anyway.