mds-cos
asked on
Search Access forms for specific underlying database field
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?
Does anybody know how to accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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).
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).
ASKER
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.
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.
ASKER
Thanks for getting my brain back in gear.