Analysing code structures automatically

[Michael]

I have quite a lot of code in my database and I would like to review the
code structure and eliminate duplications etc. by analysing the code so that
all of the calls to functions, procedures etc are listed in a report (or
preferably represented diagrammatically). Is there an Access function or
program to do this automatically?

For example:

Procedure 1
Calls Function 1
Calls Sub Proc 2
Calls Function 2
Calls Function 1

Procedure 2
Calls Function 2
Calls Sub Proc 3
Calls Class 3

etc.

Many thanks,

Michael.

 

[Paul Overway]

There is no native Access functionality for this. You might want to look at
FMS Total Access Analyzer.