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

  • Question

  • Is there a utility or fairly simple way to find out if/where that table field is used in queries, reports, forms, etc?
    Tuesday, November 19, 2019 4:10 PM

Answers

  • 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

    • Marked as answer by Big Itch Thursday, November 21, 2019 3:39 PM
    Tuesday, November 19, 2019 8:15 PM
  • 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.
    • Marked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    Tuesday, November 19, 2019 10:16 PM
  • 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.

    • Marked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    Wednesday, November 20, 2019 12:50 AM

All replies

  • 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

    • Marked as answer by Big Itch Thursday, November 21, 2019 3:39 PM
    Tuesday, November 19, 2019 8:15 PM
  • 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.
    • Marked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    Tuesday, November 19, 2019 10:16 PM
  • 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.

    • Marked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    Wednesday, November 20, 2019 12:50 AM
  • Thanks for the info . . .will try those things. . . .
    Thursday, November 21, 2019 3:39 PM
  • Thanks for the suggestion. . .will try that.
    • Marked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    • Unmarked as answer by Big Itch Thursday, November 21, 2019 3:40 PM
    Thursday, November 21, 2019 3:40 PM
  • Thanks
    Thursday, November 21, 2019 3:40 PM
  • 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)

    Thursday, November 21, 2019 8:58 PM
  • I believe you are correct, however, pretty sure one can still download it.
    Thursday, November 21, 2019 9:23 PM