Code to change all references to table/query

[eAlchemist]

Every now and again you want to change the name of a query, table, or field, but naturally you have to go hunting for every reference to that item in the database lest you have all sorts of troubles.
Does anyone have code to search and replace these items throughout a database?

Thanks,
Chris

 

[jdegeorge]

I copy and paste the code in Word, to a global find and replace, then paste the code back where I need it to be. Works every time.

Jim DeGeorge

 

[LambertH]

Check out Rick Fisher's Find and Replace tool. Works wonders for me.

http://www.rickworld.com/products.html