Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Change Field Name throughout Database

    I have a database created in Access 2003 and have upgraded to 2010. I want to change a few field names in the database and throughout all queries, reports and code. Is it possible to do this with a find and replace process?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,563
    Thanks
    384
    Thanked 1,480 Times in 1,346 Posts
    Kerry,

    What you need is Name AutoCorrect.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,605
    Thanks
    0
    Thanked 32 Times in 32 Posts
    I would use Rick Fishers Find and Replace if Name Autocorrect doesn't work.

  4. #4
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts
    Excellent - thankyou.

  5. #5
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts
    This is excellent too. Thankyou so much!

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,635
    Thanks
    3
    Thanked 64 Times in 63 Posts
    Note however that there are some circumstances where Name AutoCorrect can lead you astray. The article RG references gives a fairly detailed explanation of the issues you may encounter. Also, Name AutoCorrect will not make changes in VBA, so you will need to manually search your VBA project for the field names that you change. I'm not sure about Rick Fisher's utility - it's been some time since I used it.
    Wendell

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,605
    Thanks
    0
    Thanked 32 Times in 32 Posts
    Rick Fishers Find and Replace makes changes in VBA as well.

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,442
    Thanks
    1
    Thanked 36 Times in 35 Posts
    I turn-off autocorrect, and use Rick's Find & Replace.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •