Results 1 to 4 of 4
  1. #1
    Gdm is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Posts
    28

    Is global search and replace possible? Many renames required.

    I need to rename everything (!) in an Access database that contains 'abc' in the name to 'xyz' - tables, queries, fields - everything!
    Is there a global find and replace way of doing this in Access database?



    Or do I have to program this? If so, does anyone have such a function?

    Help most appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Not within Access alone.

    If you want to replace data, that means a search and replace on every table. VBA can be written to do that.

    If you want to make changes to design (for instance, table or field names), that requires third-party add-in tool (or writing tons of code). Review https://www.accessforums.net/showthread.php?t=54828
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It can be done with VBA code quite easily, although will take some time to write. It depends how important it is to you!

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You can try v-tools
    but I would advise you to make a few backups to start, and as you proceed.

    Why do you have to rename things? Is it time to consider redesign?

    Good luck.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2017, 08:13 AM
  2. Query renames field as Field0
    By Karyn in forum Queries
    Replies: 1
    Last Post: 05-11-2015, 05:12 AM
  3. Replies: 16
    Last Post: 04-01-2014, 12:22 PM
  4. Replies: 2
    Last Post: 09-11-2012, 12:34 PM
  5. Macros for global search
    By joypanattil in forum Access
    Replies: 2
    Last Post: 11-28-2009, 04:30 AM

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