subdatasheet switches to [auto]

[Jason Simpson]

I never use datasheets but work in a help desk. Client just recently
installed ACC03 over ACC02. Client tries to update the subdatasheet name to
a specific table other than [Auto]. Table saves OK. When opening table in
datasheet view, subdatasheet he entered is gone. Table design again shows
[Auto]. Client states he was able to successfully enter subdatasheets in
table design in ACC02. Any idea why this is switching back to [Auto] after
seeming to have been changed succesfully?

 

[Allen Browne]

Access does this if you have not yet turned off the horrid Name AutoCorrect
boxes under Tools | General | Options.

There are litterally dozens of problems caused by Name AutoCorrupt. More
info:
http://allenbrowne.com/bug-03.html