Query automatically changing my source table

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Hi all, I'm having a rather frustrating time with Office 2007. I created an
Unmatched query with the wizard.
If I change the name of the table and go into the Unmatched query it
automatically changes the source table
to the new name. How can I stop it from doing that?

TIA
Ted
 
Ted said:
Hi all, I'm having a rather frustrating time with Office 2007. I created an
Unmatched query with the wizard.
If I change the name of the table and go into the Unmatched query it
automatically changes the source table
to the new name. How can I stop it from doing that?
Click to expand...


Turn OFF the Name AutoCorrect feature in
Tools - Options - General

This feature is also notorious for causing other problems so
you should make sure it is turned off in *all* of your
databases.
 
Back
Top