Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Need to rename a table

    Is the example given: DoCmd.Rename "Old Employees Table", acTable, "Employees" method the preferred way to rename a table?
    I need ALL DB references to the table to inherit the new name. It's easy to find references in any of the code modules, but names are buried in queries, forms, etc..

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413

  3. #3
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    V-Tools from Skrol has a deep search and replace.
    https://www.skrol29.com/us/vtools.php

    The other method is to turn on the AutoName Corrupt feature and in theory that will update everything, but I'm not sure how reliable it is.
    I also seem to remember you have to open any object for it to update.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Thanks Minty, V-Tools carried out the task. Not surprising, new table names are created as alias in the front-end while leaving the back-end table names intact.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-12-2021, 06:54 AM
  2. Rename a table
    By lamore48 in forum Programming
    Replies: 4
    Last Post: 08-01-2018, 05:22 AM
  3. ALTER TABLE rename a column
    By rockell333 in forum Queries
    Replies: 8
    Last Post: 09-18-2015, 02:59 PM
  4. Replies: 4
    Last Post: 11-05-2010, 04:56 AM
  5. How to rename a linked table which link to ODBC
    By Connie1122 in forum Database Design
    Replies: 6
    Last Post: 08-02-2010, 02:43 PM

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