Shortcuts for fixing all object types after renaming a table? (1 Viewer)
- Thread starter Hello1
- Start date
vba_php
Forum Troll
- Local time
- Yesterday, 19:30
- Joined
- Oct 6, 2019
- Messages
- 2,880
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....
apr pillai
AWF VIP
- Local time
- Today, 06:00
- Joined
- Jan 20, 2005
- Messages
- 735
Access - -> Options -->Current Database - ->
Put Check Marks under Name AutoCorrect Options
Put Check Marks under Name AutoCorrect Options
- Track Name AutoCorrect Info
- Perform Name AutoCorrect
isladogs
MVP / VIP
- Local time
- Today, 01:30
- Joined
- Jan 14, 2017
- Messages
- 18,209
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.
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.
- Local time
- Today, 01:30
- Joined
- Sep 12, 2006
- Messages
- 15,634
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.
it's relatively easy to write a module to change query SQL, but it needs checking carefully.
