Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rename one not all (2003)

    OK, maybe I've missed this in my search but I can't believe this is not as widespread an issue as it appears.

    I want to rename a table and NOT the 'references' in the corresponding queries. Now, I can see the usefulness in affecting the name change in corresponding objects, and I could certainly see if it were reflected only at a field name change. But everytime I replace one data set (table) with another, my queries get screwed up and I have to go back in manually edit the SQL.

    Is there a way to turn this functionality off? It wasn't in Tools/Options much to my chagrin.

    So, hopefully this is as obvious as it seems and I won't need to post code to have it ring a bell with anyone.
    Thanks in advance for any help rendered.

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename one not all (2003)

    It is in Tools/options... Look for "Name Auto Correct" and uncheck the Track name AututoCorrect Info

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename one not all (2003)

    Awesome...thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •