Shortcuts for fixing all object types after renaming a table?

[Hello1]

Hello,

Is there something like a shortcut for doing this instead going through every query, form, report and code line for fixing them with the new name of the table?

Thanks

 

[Galaxiom]

V-tools Total Search.

 

[vba_php]

Hello,

Is there something like a shortcut for doing this instead going through every query, form, report and code line for fixing them with the new name of the table?

Thanks

are you talking about the rest of the objects that use the renamed table in a dependency situation? as in, a form that uses the old table as a recordsource, but becomes a broken dependency when the table is renamed? if so, vba should be able to fix it with a small routine. it looks like it might be included in galax's link....

 

[Hello1]

Yup thats what I wanted. The tool above looks good but I went with the Database Documenter because I started before seeing the tool. However, good to know about it.

 

[apr pillai]

Access - -> Options -->Current Database - ->
Put Check Marks under Name AutoCorrect Options

• Track Name AutoCorrect Info
• Perform Name AutoCorrect

 

[isladogs]

Autocorrect can be very useful though many developers avoid using it as it can cause issues. I do use it but with care.
Whatever your view about the feature, it doesn't update names in module code or macros. So you would still need to deal with them separately. V-Tools is free and can also replace names in module code but not macros.

 

[gemma-the-husky]

if you change a table name, (or a field name) you will need to fix any query or code using the table name. It may autofix, and you may have tools that can do it, but it's worth checking before you publish the change. If you include spaces in the new name you will need to add square brackets round any identifiers.

it's relatively easy to write a module to change query SQL, but it needs checking carefully.