Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an Excel file that has been set to share via Tools | Share Workbook. I have the worksheets (there are three worksheets in the workbook) in this Excel file set up as linked tables in an Access 2003 mdb file. I can open any one of the three linked tables in Access. I then open another instance of the same Access mdb, but I cannot open the same linked table in this second instance that I have open in the first Access instance. So much for Excel file sharing.
    Also, if I attempt to open the workbook directly in Excel while having one of these linked tables open in Access, Excel complains saying: Cannot access 'filename'

    Am I missing something or can't Excel files be set up for use in an Access multiuser environment?

    Thanks in advance for any help on this.

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Bellevue, WA
    Posts
    61
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I'm not sure this helps, but here goes. I'm using Office 2007, but suspect it is much the same. I used Review - Changes - Share Workbook. Then under the editing tab, I selected "Allow changes by more than one user at the same time." I then linked to the workbook in two different Access applications. I could open both and view and edit. Without the selection in the editing tab checked, I could open the table in only one instance at a time.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by Larry Engles View Post
    I could open both and view and edit.
    Could you really Edit the linked tables in Access?
    Microsoft says you can't. They had to remove that a few years ago for legal resons.
    Regards
    John



  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Larry Engles View Post
    I'm not sure this helps, but here goes. I'm using Office 2007, but suspect it is much the same. I used Review - Changes - Share Workbook. Then under the editing tab, I selected "Allow changes by more than one user at the same time." I then linked to the workbook in two different Access applications. I could open both and view and edit. Without the selection in the editing tab checked, I could open the table in only one instance at a time.
    Well, this is how I am doing it in Excel 2003 and it doesn't work. Actually, checking the "Allow Changes..." check box is required if the file is to be shared. If the check box is cleared then the file is no longer shared.

    I am aware of what John is pointing out; that the linked table is read-only due to the legal situation, but that is OK as I want the data for reporting purposes only.

  5. #5
    Star Lounger
    Join Date
    Dec 2009
    Location
    Bellevue, WA
    Posts
    61
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by John Hutchison View Post
    Could you really Edit the linked tables in Access?
    Microsoft says you can't. They had to remove that a few years ago for legal resons.
    You are right. Can't edit. It only looked like I could .

Posting Permissions

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