Identify if a Table Field is used in any queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run 2nd query using results from 1st query 0
Parsing a table 1
Refresh Table 3
What queries / tables are used? 2
Charts from Select Query - Fields not recognized 1
Setting criteria in query 2
Use a form control value to filter query only if form is loaded. 3
Using select query results as filter for append query 14

Back
Top