Search Access forms for specific underlying database field

mds-cos
mds-cos used Ask the Experts™
on
I need to search through all of the forms and reports in a large Access XP database to determine what forms and reports use specific underlying database fields.  This is a one-time thing (I hope), so does not need to be fancy.

Does anybody know how to accomplish this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
try using the Find and Replace tool

http://www.rickworld.com/products.html
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
There is also Total Access Analyzer from www.fmsinc.com. I own both F&R and TAA and have found TAA to be more complete, although quite a bit pricier.

Author

Commented:
Wow, don't I feel stupid!  I forgot that I downloaded the free MDBsearch (UCORA) tool a long time ago for something else.  See how often I have to do stupid stuff like searching forms for a field.

Thanks for getting my brain back in gear.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
I don't want to buy anything for a simple search, but am going to check out TAA to see what other type of analysis info it gives me.
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
Do you mean this:

http://www.svalovic.com/?MDBSearch

If so, this won't tell you anything of that nature ... it searches tables for string values.

If that's not it, a link to this tool would be in order, I believe.

<I don't want to buy anything for a simple search>

This is anything but a "simple search" ... this would be an extrememly invasive process, and would take a LOT of code to generate a decent and robust cross index (hence the reason for 3rd party utilities to do this).

Author

Commented:
Yes, that is it tool.  And yes, after I pulled it up I realized that it does not search like I need it to.  I'm going to try the other tools.

Seems like it should not be that difficult to iterate through all the fields of every selected object type, pull the source field, and compare to a search string (I'm obviously ignoring the case of a query as the form source with select <record> as aliasname).  Course, as we all know something that seems like it should not be difficult often is.

Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial