Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Washington (not DC)
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked file and server access (2000 - SR-1)

    We have a query which is linked to an excel spreadsheet, both the database and the excel spreadsheet live on the server. Of three people, only one is able to access the query. All three can access the database with no problem, but not the query that links to the excel file. The excel file is in a separate folder from the database. We receive the following message ('F:beroutputsoutput.xls' is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides.) Path names, etc are spelled correctly and yes, they are connected to the server. All three pcs have this correct 'drive' mapped and as I said, they can access the Access database without problem. Could anyone give me a clue as to where/how to troubleshoot this further. TIA

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

    Re: Linked file and server access (2000 - SR-1)

    Access is a multi-user application, but Excel isn't. It seems that even if the workbook has been set up as shared, opening the workbook through Access is exclusive...

    Would it be possible to import the Excel table into the Access database?

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Washington (not DC)
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked file and server access (2000 - SR-1)

    This has not bee the problem as only one person was trying to utilize the file at that given time. But, thanks for the thoughts and will definitely keep awares of this for future thought with this database.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linked file and server access (2000 - SR-1)

    Can the users who have a problem open the file directly using Excel? If not it's likely a permissions problem on the file itself - is it on a NTFS drive? If they can, then it could be a permissions problem if you have setup User Security. Hopefully one of these will show results.
    Wendell

Posting Permissions

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