Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005

    Unanswered: Can't link to *.xls table on http server

    I'm trying to link to a http server. My parent table resides on my server at http://servername/files. I can go into Internet Explorer and simply type http://servername/files and hit go, get a dialog box requiring login and password and bag here's all my files; one of which is a my parent table people.xls. If I click on people.xls out of Internet Explorer the file opens normally in Excel.

    That being said when I choose File->Get External Data->Link Tables in Access 2003 I am allowed to type in http://servername/files/people.xls. A box pops up and asks for login and password. I type this in, and hit enter. A box pops up for a fraction of a second, too quick to read but it says something like "connecting to the server, or communicating with the server." Anyway that screen quickly goes away and another pops up saying that Access is unable to communicate with server, verifiy address and file name were typed correctly. I am sure they were.

    Anybody have any clue why I can view/open these files from any computer station on our network in Internet Explorer but for whatever reason Access can't link to it? Do I need to start all over and use some sort of TransferSpreadsheet Macro? Is there something with the server that needs to be changed to let Access in?

    Last edited by ranger3484; 11-08-05 at 03:43.

  2. #2
    Join Date
    Jun 2003
    I don't really think that a local Access database can be linked to an online Excel file (although it does seem like it could be convenient at times if it would work).

    And here's a little more about using an online Access database via ASP pages:

    Web Database Concept
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    HTTP: IS for display the HTML

    If the server is in your network

    try \\servername\files\bla.mdb or .xls

    So When Linking a Database over the network
    link by the \\servername\files\bla.mdb or .xls

    + for this Is the you don't have to map the Drive ( what the user can't see can't deleted)

    - If you upgrade the server and give it a differance name the you will have to relink the tables
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  4. #4
    Join Date
    Nov 2005

    Thanks for your help

    I'll give the //servername/files/people.xls a try vice the http://servername/files/people.xls

    If it makes any difference I made a practice link in a simple Power Point slide and mapped the link to http://servername/files/people.xls and it worked great. For some reason Access can't get to it. Not sure why. Again, a box pops up saying "Connecting to the Server," then goes away followed by a the message "The wizard is unable to access information in the file 'http://servername/files/people.xls'. Please check that the file exists and is in the correct format. I've even mapped a network drive to this server and clicked directly on the file so I know it's there and I'm not mistyping the path or filename.

    Last edited by ranger3484; 11-11-05 at 00:01.

  5. #5
    Join Date
    Nov 2005

    Red face Still not working

    Well I tried the //servername/files/people.xls No dice. This one is really stumping me. How come I can create a link in Word or PowerPoint, write the path to http://servername/files/people.xls and everything works fine, but when I try to link tables and use the exact same path it doesn't work? Not sure if Access uses something different in the linking process or what.

    The paper and pencil will be coming out.


Posting Permissions

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