Results 1 to 7 of 7

How to rename a linked table which link to ODBC

  1. #1
    Connie1122 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7

    How to rename a linked table which link to ODBC

    When create the linked table to ODBC, it automatically create the name with user name like abc_tablename. How to rename as tablename ? thanks

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,860
    Right click on the table in the navigation pane and select Rename.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    Connie1122 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7
    Thanks for the reply. But I did not see "table" and "rename" on toolbar. This is converted from an existing Access 97 app, and I can't right click on the linked table,
    any idea? thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,860
    I didn't say toolbar, I said Navigation Pane. You are using 2007, correct? Hit F11 to get the Nav Pane, then see attached.
    Attached Thumbnails Attached Thumbnails Rename.JPG  
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  5. #5
    Connie1122 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7
    sorry, I mean navigation pane, when I click on the linked table, I am not able to right click , dunno if it is because of converted from other version?
    separately , do you know how to automatically enable the content? now when I open the file, it show msg that not run in disabled mode, and I have to go to security option to enable to content. Thanks in advance.

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,860
    Not sure about the right-click; I've always been able to do it.

    To automatically enable content, the db must be in a "Trusted Location". That is set in:

    Office Button/Access Options/Trust Center/Trust Center Settings/Trusted Locations
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  7. #7
    Connie1122 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7
    Thanks for answering my questions.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2010, 07:29 PM
  2. Import or link fields via ODBC
    By smoked1 in forum Import/Export Data
    Replies: 9
    Last Post: 10-30-2009, 02:55 AM
  3. ODBC error with Linked Table Manager
    By Andersd in forum Import/Export Data
    Replies: 1
    Last Post: 10-29-2009, 11:08 AM
  4. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 06:30 PM
  5. ODBC Linked Tables Become Unupdateable
    By dollardeveloper in forum Access
    Replies: 0
    Last Post: 04-08-2009, 06:13 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
  •  
Tech Forums: Microsoft Office Forums