Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UNC addressing for linked tables (Access 2002)

    When I try to link a table using a UNC address Access comes back in error, the error is:
    The folder savdan1administration isn't available. The folder may be located in an unavailable location, protected with a password, or the filename contains a / or .

    Has anybody had experience linking tables across a network using UNC as the form of addressing, if so, what is my problem?

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

    Re: UNC addressing for linked tables (Access 2002)

    Show us the code you're trying to use. You should be able to use UNC in Access 2002.
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: UNC addressing for linked tables (Access 2002)

    I'm doing some work with Reece. What we tried was to manually link to tables across a network using the UNC rather than the letter assigned to that network server.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UNC addressing for linked tables (Access 2002)

    That should work, I've done it many times, and just now tried it again as a test. Make sure the UNC path is exactly correct.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: UNC addressing for linked tables (Access 2002)

    We were trying to link manually in the Link box as shown.

    Is that what you also tried just now?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UNC addressing for linked tables (Access 2002)

    Yes, that's exactly how I did it.
    As a test, try entering only srvdan1 in the Filename box to see if the server is recognized. If not, you have a problem, otherwise, try srvdan1administration as next step.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: UNC addressing for linked tables (Access 2002)

    Thanks Hans, I will try that tomorrow morning.

    I will let you know how it goes.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: UNC addressing for linked tables (Access 2002)

    Well Hans it is now working. I had omitted to include the sharename after the servername.

Posting Permissions

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