Identify if a Table Field is used in any queries

D

Dawn

I'd like to know if there is a way to find out if a particular field in a
table is used in any queries. I want to delete the field in the table, but
don't want to make any queries inoperable. I'd rather not individually open
all of the queries. Is this possible?
 
J

Jerry Whittle

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans.

http://www.rickworld.com/

However in your case you might not even need the cross-reference report. You
could make a copy of the database, then find and replace the name of the
field in question. F&R will look for that name and you could see where the
field is used elsewhere.
 
Top