Global Find And Replace Using A Recordset

[Moonshine]

Hi All

Due to our ICT department, we need to bring our databases upto their naming convention standards. I have one database, with over 23000 lines of code behind around 20 forms.

I have a table with the [Old Field Name] and [New Field Name] what i want to do, probably using a module is search through ALL the forms code, and find the [Old Field Name] and replace it with [New Field Name].

Ive done this for the Control Source of text boxes, and that works fine. I jsut cant get it to work for all the Code.

The table that holds the data is called "FieldMapping", and the field names are as above.

 

[ghudson]

You need to use a program called Speed Ferret. It is not free but I have read many postings where the users stated it was a great program for safely renaming all database objects.

http://www.moshannon.com/speedferret.html

 

[Moonshine]

Hi and thanks for the URL

Just having a play around with the program, and i cant seem to find a place where it would let me at a list of what to find, and what to replace with.

Dont suppose you have seen this option anywhere?

 

[ghudson]

I have never used Speed Ferret. I just see it mentioned when folks like you have a need for it's services. I doubt that it stores a listing of things to find and replace. I imagine that the user will define one search string to find and one string to replace the findings with.