Linked Table using System DSN - How Chg DSN name ???

[Dylan]

I have changed the server that a number of access db's have linked tables to. I could not find an option that would allow me to modify my linked tables to the new system DSN name.

Can this be done ??? Or do I have to relinnk every table again and point to the new sys DSN in that process.\

Thanks


Tom

Tom Moran
Lansing, Michigan

 

[Mute101]

Hi Tom,

You should check out the Tools>Database Utilities>Linked Table Manager. From there you can select the tables you need to update and repoint to a new DNS.

I think thats what your after

Simon

----------------------------------------
I was once asked if I was ignorant or just apathetic. I said, "I don't know, and I don't care."
----------------------------------------

 

[PHV]

You may take a look here:

http://www.peterssoftware.com/tlk.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244