Link to home
Create AccountLog in
Avatar of ComputerFundi
ComputerFundiFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access db documentation - table / query / form / report / module / macros relationships

Is there a utility or add-in for access 2003 which would enable me to discover the links between object types in a db?

I've inherited a moderately complex db without documentation and so want to find out whether and objects are redundant & 'what lies beneath' a given form or report. For example, what are all the queries, tables, macros, and modules used to present the ata to the form and execute the actions. I could do it all laboriously manually. But is there a quicker, easier way?
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

You can try the Access Database Documenter

Open the Database, then use the Tools Menu:

Tools>Analyse>Documenter

AW
Avatar of ComputerFundi

ASKER

yep, I've already looked at that but it only gives be information about individual objects, not the relationships between them.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Also in A2003, you can do this:

1) Tools>>Options>>General Tab:
Check 'Track name AutoCorrect info'
** DO NOT* check 'Perform name AutoCorrect !  Or you have many automatic replacements you do not want, as well as other associated issues related to this particular part of the option.

Close the Options window, then try this for example:

Right click over a table or query in the database window.
Select 'Object Dependencies'
You will get a one-time message  about info needs to be updated. Click OK.
Then, on the right side of the App window, Access will list the dependencies.

However ... be SURE ... to read the WARNING at the bottom of the window"
"WARNING" Some objects were ignored" to understand what this option does *not* check, which included VBA code.

mx


Thanks DatabaseMX - exactly what I'm looking for.