Name auto correct is quite dangerous which is why we recommend that it be turned off. However, if you knw what it does and you want its help, you can turn it on, make your changes, and then turn it off again. What trips people up with NameAutoCorrect is that people don't understand exactly WHEN the change gets propagated. The answer to that is, the next time you open the object that was affected. So, if I change columnX to columnY, the change is logged in the change log but nothing else happens. Then when I open query1, columnX is renamed to columnY. Then I open Report1 and columnX is renamed to columnY, etc. ChangeAutoCorrect NEVER changes VBA. It only changes querydefs and bound controls. It doesn't change calculated controls. So if you have a control --
=ColumnX * .45
ColumnX will NOT be updated (unless something has changed).
So, make sure you know what you are doing and are prepared to open ALL objects that might be affected. You don't want to leave them, because if you turn off Name Auto Correct any object that would have been affected will not be updated if you din't open it before you turned off the property. I attached some documentation as well as a PPT that I created for a presentation and a database you can experiment with.
Do NOT turn NameAutoCorrect on unless you understand what it does.