Relationship ?

[a24t42]

I have been working on cleaning the dead wood out my database. I am so
afraid that I am going to delete something I might need. Is there
anything built-in in Access that would help in this endeavor? Is there
a easy way to see what forms and reports use what queries, etc.

Thanks in advance.

 

[Guest]

Although it is not free, this is an excellent tool:

Total Access Analyzer
http://www.fmsinc.com/products/analyzer/index.html

The built-in Object Dependencies that Wayne mentioned is a feature that was
introduced in Access 2003 (not available in 2002 or earlier versions). It
requires you to enable NameAutocorrect. You might want to only do this on a
copy of your database. This *feature* has another name to some of us:
NameAutocorrupt.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________