Name Changes

[Jenn]

I need to change names of tables and the field names because they were named
before I learned porper naming techniques. My database is now quite large
with multiple queries, forms and reports based on these tables.
Is there a simple way to have the names changed on all these items without
me having to go through each one at a time?

 

[John Spencer (MVP)]

Products to document the database and do a global find and replace. All have
Access 97 and later versions. Some don't have an Access 2003 version, but may
still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

Even with these, you need to be very careful and work with a copy of your
database. They can change things you don't want changed if you are not
careful. I use Find and Replace and find it does an adequate job for me.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Jenn]

Thank-you I will try it.

Products to document the database and do a global find and replace. All have
Access 97 and later versions. Some don't have an Access 2003 version, but may
still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

Even with these, you need to be very careful and work with a copy of your
database. They can change things you don't want changed if you are not
careful. I use Find and Replace and find it does an adequate job for me.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Jenn]

The find & replace work extremely well.

Products to document the database and do a global find and replace. All have
Access 97 and later versions. Some don't have an Access 2003 version, but may
still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

Even with these, you need to be very careful and work with a copy of your
database. They can change things you don't want changed if you are not
careful. I use Find and Replace and find it does an adequate job for me.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County