Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change linked table fields... find all links

Status
Not open for further replies.

jojones

Programmer
Dec 4, 2000
104
AU
Hi there

I have a table (tbl1) which is stored in database A (dbA). I have several other databases which have links to tbl1. I have added a couple of fields in tbl1 and want to use these fields in queries in the databases which have a linked tbl1, but as there are loads of them, I am not sure exactly how many, I want to make sure I don't miss any.

Is there some code that can go through directories and find dbs which have a link to a certain tbl1?

Thanks
Jo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top