Where is object (table,query, form, etc) used 1

[rewdee]

To all

I've got a lousy task of documenting a pathetically designed and written Access database that will be redesigned.

I would like to create a report that outlines the object(table,query,form,etc) and in what object is it used. I think it would be a one to many relationship. For example TableA could be used in QueryA, QueryB, FormA and ModuleA.

I'm thinking I could use the MsysObjects table but can't find any documentation or suggestions in Access 97 Developer's Handbook(adh)on how to do this. Does anyone have any suggestions or code that can help me? I've also heard of an add-in that does this. Does anyone know of or where to get this add-in?

Thanks,
Rewdee

 

[Philly44]

I think what your looking for is the Documenter. Its unders Tools->Database Utilities. Unfortunately it SUCKS!!! Its next to impossible to make sence of and it generates huge reports. If you have access to Visio I would go that route. It has some really nice Database Documentation utilities. All you have to it tell it where the database is. Other than I can't help.

 

[rewdee]

Thanks Philly44

I do have Visio 5.0 Professional and it did create a nice relationship diagram. Unfortunately, this database that I'm documenting has 20+ with only three joins. So what I'm after is something that tells me where this table is used or if this code in a particular module is actually used. etc.

I don't thave the Tools>Database Utilities>Documenter. Is it an add-in? Where do I get it?

thanks again,
Bill N

 

[Databaseguy]

Actually, the Documenter works pretty good if you know how to use it. First, select the options button and fine tune what you want dicumented. Then, when you get to the report, click Save As Table on the file menu and it'll create a new tale caled object definition. Sit there and study it & you'll figure out how the new table works. Then, you can start writing queries lagainst the Object Definition table... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Philly44]

My bad its under Tools->Analyse

 

[rewdee]

Thanks, the world is a bit better place now that I have a way of documenting this mess. Although I wish that the "save as table" feature would be in a couple of tables joined together rather than one

Rewdee

 

[jjonesal]

Databaseguy -

I've used the documenter since it first came out... and never knew you could create the object defintion table....

Too Cool -- This will make life a lot easier!!!! :-D J. Jones
jjones@cybrtyme.com