change all function in access 2007 (SQL)

[cmercante via AccessMonster.com]

does anyone know of a ‘change all’ function in SQL, access 2007 that would
speed up the process of changing the naming convention of a table for example
from 1 to a 3 and that would not cause a problem for the existing queries
created?

example:
Original table name was:
ACBSDTABT1_C$ACCT

when the database was updated the table name is now:
ACBSDTABT3_C$ACCT

 

[PieterLinden via AccessMonster.com]

does anyone know of a ‘change all’ function in SQL, access 2007 that would
speed up the process of changing the naming convention of a table for example
from 1 to a 3 and that would not cause a problem for the existing queries
created?

example:
Original table name was:
ACBSDTABT1_C$ACCT

when the database was updated the table name is now:
ACBSDTABT3_C$ACCT

The fact that you're changing what amounts to a subscript on a table worries
me. Why do you need to do this? you could just include one more column in
your table and then put the value there and then filter the entire table and
store all the data together.

I just tested it on a dummy DB, and I think the system table takes care of
this for you. Make a copy of your database and test renaming the tables on
the copy. then if it fails, you can just trash the copy.

 

[cmercante via AccessMonster.com]

Its not something I've chosen to do. Its our client that changed the table
names. I will try your suggestion. Thank you.

does anyone know of a ‘change all’ function in SQL, access 2007 that would
speed up the process of changing the naming convention of a table for example

[quoted text clipped - 7 lines]

when the database was updated the table name is now:
ACBSDTABT3_C$ACCT

The fact that you're changing what amounts to a subscript on a table worries
me. Why do you need to do this? you could just include one more column in
your table and then put the value there and then filter the entire table and
store all the data together.

I just tested it on a dummy DB, and I think the system table takes care of
this for you. Make a copy of your database and test renaming the tables on
the copy. then if it fails, you can just trash the copy.