PC Review


Reply
Thread Tools Rate Thread

How change table name including references in forms and queries?

 
 
rchristopher
Guest
Posts: n/a
 
      5th Jan 2010
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.
 
Reply With Quote
 
 
 
 
John Spencer
Guest
Posts: n/a
 
      5th Jan 2010
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

rchristopher wrote:
> 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.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table field name change propogate to queries/reports/forms randyvs Microsoft Access 1 29th Oct 2008 04:51 PM
Parent/Child Table References in Forms R Tanner Microsoft Access Forms 1 16th Oct 2008 06:05 PM
Access 2007 - table field references no longer valid on forms (?) Allen Browne Microsoft Access Form Coding 3 7th May 2007 06:31 PM
Forms-Table and Queries EMILYTAN via AccessMonster.com Microsoft Access Form Coding 2 27th Apr 2007 09:13 AM
Forms to New Table/Queries shanearmstrong Microsoft Access Forms 1 1st Dec 2006 06:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:05 AM.