Mass changing table and query names 2

[jmstarbuck]

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?

 

[GingerR]

TOOLS+OPTIONS+GENERAL TAB

check boxes under NAME AUTOCORRECT

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[jmstarbuck]

Thank you! Is there a way to get a report of all the places a table or query is referenced?

 

[PHV]

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

 

[jmstarbuck]

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?