I support an older database where I see fields that I'm not sure are used . . .

Question

Is there a utility or fairly simple way to find out if/where that table field is used in queries, reports, forms, etc?

Answer 1

Big -

Simplicity is in the eye of the beholder …

Also of consideration is the time it takes to do such a job.

ONE approach:

1. Copy the database
2. Delete the fields in doubt
3. Run every query, form and report
4. Restore the necessary fields.

That seems pretty simple.

Looking for text becomes difficult when queries are written using the ‘*’ as a SELECT mechanism.

---

peter n roth - http://PNR1.com, Maybe some useful stuff

Answer 2

You can use the Database Tools>>Object Dependencies tab to get started. It won't filter on individual fields but will give table, query, form and report dependencies.

Answer 3

There are a few utilities around. I've used Rick Fisher's Find and Replace for nearly 20 years. http://www.rickworld.com/products.htmlStill works in Access 2016.

Answer 4

Thanks for the info . . .will try those things. . . .

Answer 5

Thanks for the suggestion. . .will try that.

Answer 6

Thanks

Answer 7

I don't think Rick Fisher (Find & Replace) is still responding to emails.

You could also look at V-Tools (free) and MZ-Tools (commercial app)

Answer 8

I believe you are correct, however, pretty sure one can still download it.