Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2009
    Posts
    3

    LockNavigationPane Action Disables Linked Table Manager

    The title pretty much says it all. I am attempting to lock the navigation pane in order to keep users from accessing certain objects so I have an AutoExec macro that disables certain categories and then sets the LockNavigationPane action to true. However, I've noticed that as soon as the macro runs Access grays out the Linked Table Manager. I've confirmed it is the LockNavigationPane action that causes this by running just that one action in the macro and, sure enough, no Linked Table Manager.

    This doens't make sense to me, and google hasn't been any help so far. Has anyone encountered this or found a way around it?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why do you need the Linked Table Manager in this situation? Do you not relink from code?

  3. #3
    Join Date
    Nov 2009
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    Why do you need the Linked Table Manager in this situation? Do you not relink from code?
    Several of the linked tables come from local databases stored on the users hard drive. Since I can't guarantee the location of these databases, the user has to use the Linked Table Manager to choose the location.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Did you look at the link I posted? It takes care of that issue as well.

  5. #5
    Join Date
    Nov 2009
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    Did you look at the link I posted? It takes care of that issue as well.
    Wow, I completely skipped over that sentence. This may be exactly what I need to get around this strange correlation Access has between locking the navigation pane and disabling the linked table manager. Thanks.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Post back if you need additional assistance.

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

Similar Threads

  1. ODBC error with Linked Table Manager
    By Andersd in forum Import/Export Data
    Replies: 1
    Last Post: 10-29-2009, 12:08 PM
  2. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  3. Linked Table Manager Problem
    By tallerthantrees in forum Access
    Replies: 4
    Last Post: 08-17-2009, 03:58 AM
  4. Using Linked Table Manager --Can't get it work
    By cccgsmith in forum Access
    Replies: 6
    Last Post: 03-11-2009, 06:43 AM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 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