Question Structure/Inventory Tool

[dim1962]

Hi All,

I need a tool which can extract from an access database the entire configuration / structure and finally display all forms, reports created on which table or query.
Sure could be even better if can display to all the objects (buttons, fields…)
Example: Forms F1 contains fields F11, F12, F13; commands C11, button C12 which open another form F2…
Then this form F1 is created on Query Q1 and Q1 contain Q2 and Q3…
Then Q3 is based on Table T1 with fields…

Maybe exist already a tool to create this inventory objects…

Can you help me?

 

[HiTechCoach]

Hi All,

I need a tool which can extract from an access database the entire configuration / structure and finally display all forms, reports created on which table or query.
Sure could be even better if can display to all the objects (buttons, fields…)
Example: Forms F1 contains fields F11, F12, F13; commands C11, button C12 which open another form F2…
Then this form F1 is created on Query Q1 and Q1 contain Q2 and Q3…
Then Q3 is based on Table T1 with fields…

Maybe exist already a tool to create this inventory objects…

Can you help me?

Check out this list of developer tools. Specifically FMS.

Developer tools list at hitechcoach.com


I am actually writing a tool similar to what you have described. The output will be into a database. It will later be used to generate web based manuals/documentation that can be linked to the database for a help system.

 

[dim1962]

Thanks for reply.

Even if is too long, for the moment I have to du it manually because I can't find any special tool made for it.
Like you said you'll develop something, so for the future will be match easier...

Thanks again!

 

[HiTechCoach]

Thanks for reply.

Even if is too long, for the moment I have to du it manually because I can't find any special tool made for it.
Like you said you'll develop something, so for the future will be match easier...

Thanks again!

I am developing my own tool because of of very special needs with the output format.

Did you look at FMS's Total Analyzer? Is that close to what you want?

It would really help to know what you are doing.

Why you need this?

What output format do you want?

What are you wanting to do with the information?

 

[dim1962]

Good Morning,

Excuse me for the delay.

OK! I need it, because my access 200 application is now match bigger and complex.
I started to develop this application since 2000 and we still have others features to add.
Presently are a lot of users connected by network, to this database.
When I need to do a modification, I have to see the impact (dependencies) to all the other objects.

Example: Let’s say that I have to change the type of field in one table (total: 100) from numerical to text.
After that a lot of forms will become non functional, because the rlated queries was changed and that because the table was changed. In place to test all forms to see which are affected (300 forms) and go one by one in each related queries, I like to have a “MAP” where I can see all these dependencies. So in this case I can go direct to the respective affected forms and queries saving a lot of time. (So the form x was build on query y, query y on query z...etc)

If you think that the tool what you developed cold be good for me, please send me the right link direct to it.

Thanks a lot and have a great day.