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?
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
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 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
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.
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.