Results 1 to 2 of 2
  1. #1
    MFS is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235

    Linked Tables not accessible for some user

    I have an issue with linked sql tables with my Access front end, and I am hoping that I am posting in the correct Forum.



    My DB resides on a Network Drive,
    I split my database and the tables now reside on an SQL server.

    Most all user are able to run the DB once I had set up their ODBC connection.

    Other users have an issue stating "Cannot Find Linked Tables"
    When I create the ODBC connection for the said users the users that were able to run the DB are now getting the error!

    I hope this makes sense.
    What could be the issue?

    Speck

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    make SURE you did not attach the files using drive letters, S:\folder\...
    some folks don't have that letter.

    DO use UNC paths, staring with the server...
    \\server\folder\folder

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

Similar Threads

  1. How to make Access more accessible for non-users
    By devonlatour in forum Access
    Replies: 4
    Last Post: 01-05-2015, 11:23 AM
  2. Replies: 4
    Last Post: 11-22-2013, 11:20 AM
  3. Replies: 3
    Last Post: 06-14-2012, 08:10 AM
  4. Replies: 5
    Last Post: 02-02-2012, 06:42 PM
  5. Oracle CLOB not accessible in ACCESS
    By saccitylocal in forum Import/Export Data
    Replies: 0
    Last Post: 08-31-2010, 10:29 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