Results 1 to 2 of 2
  1. #1
    Bedsingar is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jul 2011
    Posts
    12

    Find and Replace

    Hello,

    As a newbie to database design I've messed up and named all my tables poorly.
    Whilst the queries all work, I've spent a lot of time mapping out all of the
    tables and queries & their relationships. I'd like to rename all of the


    tables according to their ID on the map, but know that doing so doesn't
    update the relationship.

    Is there a tool/code that will let me do a 'find and replace' on the SQL
    query code to swap out any instances of the old table name with the new table
    reference?

    Thanks

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Rick Fisher Consulting

    www.rickworld.com/download.html


    has "Find and Replace 9.0" that has been highly recommended

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Find and replace tabs from data
    By mentose457 in forum Access
    Replies: 9
    Last Post: 12-06-2010, 09:11 AM
  2. Find and Replace query from a 2nd table
    By elightbox in forum Queries
    Replies: 1
    Last Post: 09-17-2010, 05:37 PM
  3. Dumb question about find/replace
    By Perplexed in forum Access
    Replies: 11
    Last Post: 08-04-2010, 09:53 AM
  4. Find and Replace Query
    By randolphoralph in forum Queries
    Replies: 4
    Last Post: 03-17-2010, 07:25 AM
  5. Applying a find/replace function
    By Arr in forum Programming
    Replies: 2
    Last Post: 10-12-2009, 12:28 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums