Changing table/field names

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

i have a table that needs renaming, but there are many queries that use that
table. I can remember a while back changing a table name and the associated
query changed the table name automatically when i changed the table name.

Is there a trick to make maual table name changes auto change any associated
querys?
 
if you're running A2000 or later, you might try turning ON the Name
AutoCorrect feature, then changing the table name. strongly recommend you do
the following, though:

1. try this on a COPY of your database, so you can just discard the db if it
doesn't work.
2. if it does work: create a new blank database and immediately turn OFF the
Name AutoCorrect feature. then import all the objects from your database
into the new one. the goal here is that you want a clean database with Name
AutoCorrect turned OFF - that feature causes tons of problems and headaches
that you don't want dogging your database.

note: Name AutoCorrect will not correct the table name in code, or in
expressions in calculated controls or query fields, AFAIK. you'd need a
third-party product to do that.

hth
 
what exactly will it change?


tina said:
if you're running A2000 or later, you might try turning ON the Name
AutoCorrect feature, then changing the table name. strongly recommend you
do
the following, though:

1. try this on a COPY of your database, so you can just discard the db if
it
doesn't work.
2. if it does work: create a new blank database and immediately turn OFF
the
Name AutoCorrect feature. then import all the objects from your database
into the new one. the goal here is that you want a clean database with
Name
AutoCorrect turned OFF - that feature causes tons of problems and
headaches
that you don't want dogging your database.

note: Name AutoCorrect will not correct the table name in code, or in
expressions in calculated controls or query fields, AFAIK. you'd need a
third-party product to do that.

hth
Click to expand...
 
AFAIK, it will change the names of tables directly referenced in queries, in
form RecordSource properties, and in report RecordSource properties. i can't
give you a definite answer because 1) i never leave Name AutoCorrect turned
on in a new database, and 2) i never change the name of a table after i
finish the table/relationship structure and move on to the next step in
building the database.

my previous response was a suggestion of something you can *try*, not an
"i've-done-this-before-and-it-works" solution. since the end user should
never see a table name, personally i never change a table's name once i've
built other objects based on it - offhand, i can't think of any situation
where you would absolutely need to change a table name.

hth
 
Back
Top