We are going to be totally reorganizing our network. We have far too many access databases to count and the majority of them are interlinked. Is there a tool or piece of code that I could use that would to one of the following.
Give me a list of the tables attached in each database and where they originate from.
OR
When given a path/dbname/tablename give me a list of every database that has this table attached to it.
A big undertaking I know, but it sure beats having to open each and everyone and make lists.
TIA
D
Give me a list of the tables attached in each database and where they originate from.
OR
When given a path/dbname/tablename give me a list of every database that has this table attached to it.
A big undertaking I know, but it sure beats having to open each and everyone and make lists.
TIA
D