Question Object Dependencies (1 Viewer)

[Poppa Smurf]

Using the System Tables in 2003, is it possible to list for each object
1. Other objects that depend on the object
2. Objects that the object depends on?

 

[John Big Booty]

Do any of the additional tables that area available, from Tools menu Options sub menu and check System Objects on the View tab, help you out?

 

[Poppa Smurf]

John

I know how to display the system tables. But I want to know how I can use these tables to produce my requirements.

 

[vbaInet]

To do it properly you would have to code it using the collections in CurrentProject. There's also some information for TableDefs in the MSysRelationships table.

Maybe you might be tempted to go for this:

http://www.fmsinc.com/free/newtips/access/accesstip21.asp

 

[Poppa Smurf]

Yes, I am aware of this method. I would like to produce this data into a table so that I can add additional fields

The current database has about 15 tables, in excess of 100 objects tables,queries, forms, reports and modules etc. with No documentation showing how the objects interact with each other.

 

[vbaInet]

The link provided is a paid-for utility that does that.

 

[vbaInet]

I came across these so you might find them useful:

http://allenbrowne.com/ser-41.html
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

I've not tried them out by the way.