Question Re Renaming Objects

[RHONDAK72]

Normally, when a object (e.g. query, table, etc.) is renamed, the dependent objects autocorrect themselves so that they link automatically to the updated name. I'm need to rename many tables and queries in an existing database and I'm finding that the autocorrect is not working.

I suspect this issue has something to do with the fact that the database was previously an Access 2003 database (mdb) that was later converted to an Access 2010 database (accdb)...

Has anyone else experienced this problem and are your aware of a simple fix?

Thanks

 

[jackd]

Not aware of any simple fix. We often see posters who have taken over responsibility for a database where the names of some objects or fields are not to their liking. They ask "Are there any issues with changing the names of objects or fields?".
Most responses are DON'T DO THAT. It is unlikely you will find every instance. Also, it is very time consuming (can be) and not a whole lot changes in the end. Bottom line is is the effort cost justified. Often people are advised of 3rd party search and replace functions.

The real issue may be the amount of vba code in which names of "things" are adjusted/renamed. Sometimes fields and tables have been aliased in sql statements either direct SQL or vba created SQL.

There is a utility that is often recommended called VTools (I believe that's the name). It does quite in depth searching for "strings" and more.
The answer is not straight forward, as you can see. Make backups if you proceed. You can get into a real mess if you change some things but not all. If this is a critical production system determine if it is about to be redesigned redeveloped in near future.
Do you have any documentation? How is the system from a easy/difficult to maintain view?
Anytime I have seen this type of question, the answer at best is proceed with caution and lot's of backups. Have a plan and follow it.
I would not trust the built in "autocorrect" to do what you are asking. You could try it, and it may be perfect for your situation, but I'd anticipate having to track down and manually adjust a lot of info.

Good luck with your project and decision.

 

[xenou]

autocorrect has limitations. I find it doesn't fix names in expressions, or, of course, in vba. Best is don't rename objects!
Some info on known limitations here: Microsoft Access Flaws - Failures caused by Name Auto-Correct

(Allen Browne's advice is to not even enable name autocorrect. I actually follow his advice, even though in simple databases name autocorrect seems somewhat helpful. But I won't trust this for serious applications. So I have an access database created from scratch where I turned off name autocorrect. Every new database I create is based on this one). For what it's worth, I still use mdb file formats for all my work so I can't speak for the newer versions of access.