Naming convention query

[Toolpusher]

Our company has inherited a DB that works fine but has not been build with a naming convention,VBA has no comments and the macros are named "macro1" etc. Tables and forms have spaces in their titles and no leading tbl or frm. I have been given the task of cleaning this all up. I have commented the VBA but Is there any software out there that I could use to quickly do this?and make my life easier again

 

[vbaInet]

Search for MZ-Tools. It will help with deep Search and Replace.

 

[Galaxiom]

Extensive renaming can be a nightmare even with a search tool. Complete retesting is required and it is very easy to miss problems. Generally the potential for introducing problems far outweighs and perceived benefits of making changes in a currently smoothly functioning database.

While names like Macro1 are aweful many developers consider the use of Hungarian notation somewhat overblown. I certainly would not undertake renaming just for the sake of it.

 

[gemma-the-husky]

I would not bother.

poor naming can just make maintenance tricky, because it is hard to follow the programme logic. so maybe just fix odd things as and when you make improvements.

otherwise you will spend ages understanding exactly what a programme is doing - which may be worthwhile but may not be the best use of your time.

as long as all the interaction is done thorugh menus, no-one will ever need to use any of the mis-named stuff directly anyway.

one problem with auto-renaming is that you may rename something to the same as a variable you already have, which will cause more problems.