Auto update of table names in query...

[Therat]

When I change the name of a table, why do some of my db's automatically update the table name in queries and some don't update. Is there a trigger mechanism for a query to automatically update the table name?

Thanks in advance!

 

[Pat Hartman]

Change propagation is handled by the feature called "name auto correct". You can turn it on/off in Tools/Options. This feature is new with A2K and is buggy. You need to upgrade to Office service pack 3 if you are using A2K. Also, and I don't know if service pack 3 fixes this, it won't work on databases converted from A97.