Changing Table Names - Query Updates

[rjonas]

I have a feeling this either can't be done or it's so simple that I can't readily see the solution...

From time to time, I have a need to rename table(s) in my databases. This causes some issues with queries where these tables are used, since the query no longer sees the original table once it has been renamed.

What I'd LIKE to do is to be able to do a global update of all queries and update/change the table names this way..

What I've BEEN doing is making a copy of the table whose name I am changing, opening the queries (one by one), showing the "new"/renamed table, updating the affected fields and then deleting the "old"/original table...

Needless to say, this is quite tedious and not at all efficient...

Any ideas on a more systemic and quicker way to make these updates? I think what I'm looking for is an Excel-like capability where when you change a sheet tab name, any formula within the workbook automatically updates to the new name...

As always, any constructive advice is greatly appreciated.

Thanks!

Ron

 

[John Big Booty]

I believe that V-Tools has this facility. I've not used it so can not vouch for it's efficacy.

 

[jdraw]

Ron,

Just curious - Why do you have to change your Table names from time to time?

 

[rjonas]

John - Thanks.. I'll check it out! Appreciate it.

 

[rjonas]

jdraw - It's not that I have to change the table names, it's just that I don't always have the end sight to know exactly what I want my tables to be named or how I want them grouped until after i'm already designing queries, etc.

A lot of my tables are reference tables or source information and i've started building the table names with what "type" of table they are so it's clearer... I didn't think of that when I started...

Was more a curiosity question.. I thought it was odd that something so rudimentary wouldn't be easier to do in Access...