Tracking use of a field

[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

 

[Arvin Meyer]

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?

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

 

[Tony Williams]

Thanks Arvin I have 2000 so I'll check out Speed Ferret
Tony