How change table name including references in forms and queries?

R

rchristopher

Is there a way to change a table name including references in dependent forms
and queries? It looks like I would have to redesign the dependent forms
using the new table name.
 
J

John Spencer

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)

I use Find and Replace myself.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying old records into a new table 3
Table field name change propogate to queries/reports/forms 1
1->M Table relationship won't expand the dependent data 3
How to change backend field name & update queries, forms, etc ? 5
Search access Macros, Forms and VBA code for a specific table references 2
Changing a field Name - Access 2003 1
access forms 2
Keeping track of tables, queries and forms 8

Top