Best way to change a table name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have designed a database with about 10 queries and about 15 reports
depending on one table...however, the twin towers of documentation and
user-friendliness demand I change the table name.
Is there a way I can do this at once and have the change propagate
throughout the database, because I don't think right-clicking and renaming
will work!
I'm using Access 2003.

Hopeful,

John.
 
Access said:
Hello,

I have designed a database with about 10 queries and about 15 reports
depending on one table...however, the twin towers of documentation and
user-friendliness demand I change the table name.
Is there a way I can do this at once and have the change propagate
throughout the database, because I don't think right-clicking and renaming
will work!
I'm using Access 2003.

Hopeful,

John.
Click to expand...

Well, in my opinion, the *best* way is to use Rick Fisher's Find and
replace utility:

http://www.rickworld.com/products.html

Find and Replace is very reasonably priced and offers lots of extra
features beyond name-changing. If you download the freeware version you
can try it out for 30 days.

There's also a product called SpeedFerret out there, but I can't
personally recommend it as I've never used it. Many of the MVPs here use
have used it & could tell you more about it:

http://www.moshannon.com/speedferret.html

SpeedFerret is a little more expensive than F&R.

There's also some example code at
http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml

hth,

LeAnne
 
Back
Top