Hi all,


Odd request here(or so i think!). I have a need to be able to locate all query names within an entire database, that use a certain field name in the query.


a little background on this request: The developers at my company are about to launch a change to a specific field in a specific oracle table. They are no longer going to be using this field, and will have 4 other fields that will contain the data that this field currently contains.

The problem for me is we have hundreds of databases (Access), that generate hundreds of reports and/or have manual forms and systems setup in access that MAY make use of this field that is about to get changed in the next month.

So I need to be able to locate ALL queries in hundreds of databases that are currently using this field, so that when the change goes live, I can go in and switch the field out with the new fields.

I was hoping that at least the search process could be automated some how, so it could give me a least of all the queries that i need to change in any given database. I'll still have to manually make the changes I know....but at least the search process would be simplified and know how time i will have to dedicate to the changes.


Soooo if anyone knows anyway to accomplish this in MSACCESS, whether it be an application thats already available somewhere...or if someone knows some code that I could implement into VBA to do this...

Once again, I'd need to search every query within a given database, looking for a specific field name from a specific table to see if that query is using that field.

thanks!