changing links

[benjy5]

Does anyone know if there is any way to modify the path to a linked table? Like, if i move the linked table to another directory(ie i moved the database), how can i update this in my database that uses this linked table?

Is there a way w/o deleting the table and creating another linked table? If you know how to do this in VBA, that would be extra good!!


Thanks in advance!

 

[benjy5]

Thanks for the reply, Pat.

I tried what you suggested but in Access 97, it seems like the Linked Table manager can only refresh linked tables. I'm not sure if I overlooked something. Is this contrary to what you can do with your linked table manager?

ben