mess changing of object names

[itazev]

Hey guys!

I've a database which have some confusing names for its reports and forms. So as I found myself very confused when applying group policy to all the objects I was wondering if there is a way to rename those objects in a way that ALL the references in the hole database for the renamed objects will change too.

E.g.

Form_old_name -> form_new_name

then all the references will change both in the VBA code and in subforms references

I tried doing that mannualy and then using the search & replace tool to update the rewferences in the vba code. Turns out that all the database become a mess and now I have constant "out of memmory" messages

Thank you!

 

[freakazeud]

re:

Hi,
Access 2003 includes object dependency which works somewhat ok if you have the Name AutoCorrect tracking feature turned on. Otherwise you could use third party tools like SpeedFerret or Rick's find & replace.
HTH
Good luck

 

[itazev]

thanks Freak!

Rick's find & replace seems to work fine to my purpose!