Renaming Querys

[tak786]

Hello,

Im currently having a problem renaming queries. This is mainly because all the queries are linked together and changing one name will mean the rest of the queries wont work since it cant find that query anymore....

Is there a quicker way of renaming linked queries without losing the connection?

Kind Regards

Tak

[Delerna]

what version of access are you using.
Newer versions have automatic renaming functionality.
If you change a table name this functionality will automatically rename the old name to the new name wherever it is used.

You can find it in the menu's
Tools/Options and on the general tab the options
Track Name Auto Correct
Perform Name Auto Correct
Log Name Auto Correct Changes
are the ones of interrest to you. If you have the correct version that is

[missinglinq]

Be aware that Name AutoCorrect will not change names within VBA code, and I don't believe that it will change names within SQL statements. If used, it should only be turned on temporarily then turned back off, as it can slow down performance tremendously and it is reported to be a major cause of repeated corruption.

Welcome to bytes!

Linq ;0)>

[tak786]

thank you both much appreciated!