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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Utility needed to map/document linked tables

Status
Not open for further replies.

MichiLANman

Technical User
Oct 19, 2003
1
US
We are in the process of moving a very large number of departmental directories from a "K:" drive to a "J:" drive. Within these directories are large numbers (1000+) of MS Access 2000 databases with linked tables -- developed by the end users and undocumented.

What I'm looking for is a tool which could search a directory/directory tree for the MDB files and then generate a list of the linked tables. I would then use/search the generated list to produce a data relationship diagram and be able to move all related files at the same time and relink the DBs. Hopefully this would minimize the broken databases.

Anyone have any ideas?

Thanks.

Ryan

 
Are the databases secured?

If so are they secured with a standard workgroup file?

Ed Metcalfe

Please do not feed the trolls.....
 
Look into the MSysObjects table. It has a number of fields, including "Foregin Name", "Connect" and "Database", among a plethora of others. Simple inspection of the table should reveal all of the information regarding the links.

Use this:

Code:
SELECT MSysObjects.* from MSysObjects
WITH OWNERACCESS OPTION;

to generate a query which displays teh entire table. Customize it (limit the fields) to suit your needs after reviewing the available fields.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top