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
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