Tracking use of a field

T

Tony Williams

I have inherited a database which has a number of tables. One of the tables
has a field that I don't think is used anywhere. Is there any way of
checking this without running every form, query and report?
Thanks
Tony
 
A

Arvin Meyer

Tony Williams said:
I have inherited a database which has a number of tables. One of the tables
has a field that I don't think is used anywhere. Is there any way of
checking this without running every form, query and report?
Click to expand...

If you have Access 2003, and Object Dependencies is turned on, you can check
and see. For other versions, I use Speed Ferret which does more than find
instances of an object:

http://www.moshannon.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top