Linked Tables - looking for tool (1 Viewer)

[hueymoo]

We have a nasty number of access databases spread around our network and linked to each other like a giant spiderweb.
I can easily open an database and using linked table manager find out what is attached and from where.
I need some sort of tool that will tell me where a table is linked to.
IE - you have a master database that holds the data. You have several other databases that are linked to the master data and run queries, reports etc. I need to find out where the master data is used.
Any ideas?

 

[pdx_man]

I know of no tool, but the way I have done this is to rename the table in the master DB and see what breaks. Maybe not the best solution, but I am able to get the rats to leave the ship.

BTW, in the databases where the linked tables are, instead of using the Linked Table Manager, open up the mSysObjects table and filter out the blanks in the Database field. That will tell you the same info, but I think it is a little easier to work with.

 

[gemma-the-husky]

i think the best way would be to interrogate all your databases to build up a picture of the be fiels they are using

in access this string is

currentdb.tabledefs("tablename").connect

this is vbnullstring for a non-connected table

just save all the connection strings, then you can compare them at your leisure