Results 1 to 3 of 3

Thread: Rename a query

  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post
    Hi,

    I have several queries that take their data from another query.

    One of the "root" queries is badly named. Is there a way (in Access 2007 but Access 2000 file format) of renaming the query, and not "breaking" all the queries that depend on the renamed query.

    Thanks
    Jim

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could turn on Name AutoCorrect before changing the name of the query - see Set name AutoCorrect options. I recommend turning it off afterwards.

    Alternatively, you could use the excellent utility Find and Replace for Microsoft Access from Rick Fisher. Look for the Access 2007 beta version.

    Note: always back up your database before making fundamental changes!


  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post
    Quote Originally Posted by HansV View Post
    You could turn on Name AutoCorrect before changing the name of the query - see Set name AutoCorrect options. I recommend turning it off afterwards.

    Alternatively, you could use the excellent utility Find and Replace for Microsoft Access from Rick Fisher. Look for the Access 2007 beta version.

    Note: always back up your database before making fundamental changes!
    Thanks Hans!

Posting Permissions

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