Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Linked Excel File (Access 2003)

    Hi there again,

    I currently have a subreport in my database which is an excel spreadsheet, stored in a sharedocs folder on our network, when I open my database the spreadsheet opens up fine and I can view the data within the database with no problems, however if one of the other guys in our office opens up the same database which I have given them sharing rights to they can see everything in it apart from the excel file, it tells them it has been opened exclusively by another user (me)? If they open the database first they can they see it and I get the error flag any help....ta Steve in Southampton UK

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

    Re: Linked Excel File (Access 2003)

    By default, an Excel spreadsheet is single-user (unlike an Access database). When you open the linked Excel table in your database, whether directly or indirectly, it will be locked exclusively by you, and other users can't view it in your database (or in Excel itself, for that matter).
    It is possible to share a workbook, but that is not an attractive option - it can lead to corruption.

    I don't know how often the workbook is updated. If it is relatively static, you could import it into your database. You wouldn't have the locking problem then. You could repeat the import as needed.

  3. #3
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Linked Excel File (Access 2003)

    Once agains Hans...thanks very much for your time and expertise...Steve

Posting Permissions

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