Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mass changing table and query names 2

Status
Not open for further replies.

jmstarbuck

Programmer
Aug 11, 2003
90
US
I am contemplating a redesign of an Access application I inherited a couple of years ago. I will need to make several changes and additions to tables and queries.

Is there a way to mass change a table name, query name or individual field names and affect everywhere they are referenced?

If this is not possible within Access, are there tools available to accomplish this?
 
Thank you! Is there a way to get a report of all the places a table or query is referenced?
 
RightClick the Query/Table in the database window and click Object dependancy.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Wow, that is just want I need. Thank you.

Is there a way to print the information in the Tasks Pane?

Is there a good reference for these administrative tasks?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top