“User Friendly” Name Autocorrect option

Some days ago I had to send few new queries to my colleague. I created a new Access database, imported there new queries and sent it to my colleague. I do not send queries such way very often, last time it was in Access 97 time, and it worked fine there...

If a few hours he replied that application (which uses these queries) does not work, hangs, etc. How come? After some investigations – I found a following feature of Access Name Autocorrect – when you import a query into database, which does not have source table(s) – all joins between missing table(s) just get deleted without any notification! Very bad behavior! So please be careful and as soon as you create new database – switch Name Autocorrect option off. Immediately! This will save you some time later.

Other problems, caused by this “User Friendly” option you can find at Allen Browne site.