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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Globally replacing letters in Table, Query, Other Names

Status
Not open for further replies.

roxannep

Technical User
Joined
Jun 20, 2000
Messages
69
I have a database that I need to clone and then change a few letters in fields, table titles, etc. (the company name changed, and I thought this would be easier than trying to go through every table, qry, macro, etc., and manually changing two letters in the name).

Example: query titled: qryCCDailies
Needs to be: qryC1Dailies

I need this to search for both objects and field titles and any references within macros and code ....

Is there such a monster? I thought there used to be, but I cannot seem to find it.
 
Have a look here:
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Is there a solution available on any of these forums that does not require me to purchase a separate program? I don't have that kind of budget just to change the few letters throughout the dbase that we need to change.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top