How to find out all the tables contain a particular field

[itlearner]

i want to find out all the tables that contain a particular field. eg.employee_ID exists in employee table and other tables, how i can find out what are the other tables? can i run a search query to do this?

 

[RuralGuy]

If it is a one shot problem then you might try this utility:
Renaming fields and tracing dependencies

 

[itlearner]

sorry for missing mention the access version. the access i am using is 97 not 2000. i will try the utility to see it works for 97 or not.