Renaming queries

[Mlipton@cobbtool.com]

Is there a way to rename queries without destroying the integrity of the query? When we rename it 1) running the newly named query it reverts to old parameters and 2) the new name doesn't save.

[Bulzie]

Renaming queries should not cause issues within the query? What error messages exactly is it telling you? Have you tried to Repair and Compact the database? Also maybe some type of permissions if you cannot save it under a new name. Or maybe someone else has it open?

Also if you go click on Office button(top left), Access Options, Current Database, Name Autocorrect Options, check the first 2 options for Track and Perform name autocorrect so if you change name of a query it will automatically change it in other places.

[Mlipton@cobbtool.com]

Thank you! Those settings were checked in Options, but apparently not working. I unselected them and then reselected and it works fine.

[ssanfu]

But be aware that AutoCorrupt...... err... AutoCorrect is a know cause of dB corruption. I always turn it off, but there are cases when you can leave it on during development and turn it off afterwards.