Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Table Headings... (Access 2000)

    I have a potential problem I am seeking info on before I alter my universe.
    There is an issue with a HUGE table I have in Access and the field headers. I will need to change the names of the field to be in line with new corporate requirements.
    example: currently field is called [Zone Name] and I need to change it to [District Name].
    Question: If I change the name of the field in the table will ALL the corresponding references to that name be changed in the system automatically or will I have to open each query and report that make use of that data and change it manually???
    I have not done anything yet... I am trying to assess the impact of what I need to do.

    thanks!
    There is always a way.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Changing Table Headings... (Access 2000)

    >>Question: If I change the name of the field in the table will ALL the corresponding references to that name be changed in the system automatically <<

    NO! They won't be changed. The best way to handle this is with a 3rd party product such as speedferret (<A target="_blank" HREF=http://www.speedferret.com>http://www.speedferret.com</A>).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Table Headings... (Access 2000)

    Name Autocorrect *may* change it in most places, but it will not change it in macros or code. For that, you will have to take Mark's suggestion and use a product like Speed Ferret or <A target="_blank" HREF=http://www.rickworld.com>Find & Replace</A>. Plus, Name Autocorrect has its own problems and significantly contributes to database bloat as well as causing some truly weird problems, so if you do use it, turn it off afterward.
    Charlotte

Posting Permissions

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