Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: not a valid path to linked file in access

    I am linking an excel file into access 2000,and then creating a query from that information.I then am creating my recordset from that query and using it to show the data in an asp page.It works great on my local machine(xp),but when testing on my ISP server,I get this error msg..
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] 'C:\Inetpub\wwwroot\marie\Copy.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

    /marie/index2.asp, line 10

    access seems to still be looking for the excel file on my local machine..I have both the excel and access file in the same dir on both my machine and my ISP server...any ideas on how to get access to see the file in the online dir? thanks,John

  2. #2
    Join Date
    Dec 2002

    Connection on ISP

    You usually have to setup a DSN connection or set up some properties on your ISP site so that the connection can be made and then edit the code in that page to point to the location of your ISP.

Posting Permissions

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