Re link tables by user field

[ZX188]

I need to specify the path for linked tables in a database with a field in another table in a different database so that when the DB is moved to a diffrent drive the path can be changed for all my linked tables by changing the path in that field

I am not a verry good VB programmer so if this has to be done in VB as detailed of description as possable would be very helpful

Thanks in advance
Kevin

 

[kathryn]

Sorry, I don't have time to find examples from my code library, but if you look at "RefreshLink Method" in the help files, and look at the example "RefreshLink Method Example", you should get a good idea of how to start.

If you need more help, let us know. Kathryn