Results 1 to 8 of 8
  1. #1
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43

    Changing a Field name to reflect all forms without affecting relationships in DB?


    Is it possible to change a field name (same data type) just rename the field in tables and forms without affecting the DB? Help.

    Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    as long as the field itself is not in the relationship.
    (the bad part of renaming fields....dont)

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    If you left the default Auto Name feature in place I think you can. Make a copy and try.

    That feature had a strong reputation for being one of the major causes of corruption back in the 2003 era vintage and was recommended always to be turned off. I don't know if it is still the case today with more current releases.

    In any case - a table's field name is like the foundation of the house and so is very tricky to attempt to change after the house is built. You must also deal with queries if the Auto Name change feature is disabled or does not work.

  4. #4
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Thanks for the tips! I backed up the DB and playing around with changing the field names. the field name I need to change was a request from the user. fortunately it has no relation to other tables, but does populate in Forms and Reports. So far its looking okay. I basically went into design view of the original table and modified the Field name only, not the data type. And I love the analogy you gave NTC...about the tables field name is the foundation!

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    If the field is referenced in expressions, the change will likely not carry through. I use Rick Fishers Find & Replace add-in for changes like this. Saved my sanity more than once. Cost about $50. There is also a freebie called V-Tools.
    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.

  6. #6
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Quote Originally Posted by June7 View Post
    If the field is referenced in expressions, the change will likely not carry through. I use Rick Fishers Find & Replace add-in for changes like this. Saved my sanity more than once. Cost about $50. There is also a freebie called V-Tools.
    Good point June, I will have to dig back in to make sure the Field Name is not used in expression as well. is Rick fishers still around? I coulda swore I tried looking for the site and they weren't around any longer?

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    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.

  8. #8
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Quote Originally Posted by June7 View Post
    Thank you, June7. Problem is resolved.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-17-2012, 07:53 AM
  2. dropbox might be changing relationships
    By Gûlghâshbúrz in forum Database Design
    Replies: 8
    Last Post: 03-15-2012, 03:15 AM
  3. Resizing Forms (Properties affecting behavior)
    By ajetrumpet in forum Tutorials
    Replies: 0
    Last Post: 07-17-2011, 04:05 PM
  4. Can't reflect changes table-forms
    By graciemora in forum Forms
    Replies: 10
    Last Post: 06-27-2010, 03:03 PM
  5. Record relationships in forms
    By avarusbrightfyre in forum Forms
    Replies: 2
    Last Post: 09-10-2009, 04:00 AM

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