Effects of Turning Name Auto Correct Off

[meghan95]

Hello,
For a long time now I've been dealing with problem of Access 2000 reports reverting back to the default print settings when I've set them to print on Legal Paper, Landscape view.

I've read about the bug in Access that causes this with one of the suggested solutions being to uncheck all boxes related to Name Auto Correct. What are the side effects of turning off Name Auto Correct, though? It seems that this would cause more harm than good if I need to rename a field in a table or rename a query.

One of the other suggested solutions from Microsoft is to install SR-1 or 1a. My users and I are all on at least SP-3, so this fix obviously doesn't work.

I'm about ready to try turning Name Auto Correct off and was hoping for some feedback from someone who has done this successfully - what kind of implications were there for future refinement of the database?

Thanks, Meghan

 

[THWatson]

Meghan
AutoNameCorrect caused enough problems for me that I turned it off long ago, and have not suffered any ill effects, in fact am much better off without it.

The obvious downside would be if you wanted to re-name something, perhaps a Query, that was referenced by a number of forms and/or reports. You would have to fish through and find all the individual spots and make the changes manually.

However, although I haven't done it, I assume you could turn it back on to accomodate the particular re-naming, and then turn it back off again.

As you have already learned, in spite of what Microsoft says, having SP-3 installed didn't help me.

Others may have deeper experience, but that's my input.

Good luck.

Tom

 

[meghan95]

Tom,
Thanks for the input. I'm going to try it. I never thought about turning it temporarily back on, but I imagine that would work.
Meghan