Query automatically changing my source table

[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

 

[Roger Carlson]

Turn off the Name AutoCorrect Options under Access Options (start button).

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Marshall Barton]

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?

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.

 

[Ted]

Great! Thank you Roger. I figured it was a setting I was missing.