Renaming tables globally 1

[StayAtHomeMom]

Hi,
I have Access 2000. Isn't there a way to rename a table and have that change traverse thru the rest of the database and update any queries, reports, etc that used the old table name?

It seems so straight-forward, but I can't figure it out. I didn't understand the help menu concerning "Automatically repair errors caused by renaming". Does that apply to what I'm trying to do?

Thanks for any insight you can offer.

 

[jsteph]

Look on the web for SpeedFerret. It's not very expensive and I swear by it for what you want.

There is no built in way to do what it does, so if you have a lot of changes, it's cost-effective.
--Jim

 

[StayAtHomeMom]

Thanks Jim,
I researched Speed Ferret and is does sound like just what I need. Now I just have to convince the boss to spend the $200...

Thanks again,
Donna