Results 1 to 3 of 3
  1. #1
    klnlsu is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    107

    How do I prevent Excel spreadsheet from being locked when accessing in Macola?


    I have created a link to an Excel spreadsheet in Access so we can use the data in the spreadsheet as a table. However, whenever someone opens a particular query in the Access DB, it opens it as read/write and locks everyone else out of the spreadsheet. What's even stranger is that sometimes it actually opens the spreadsheet in Excel! Even when the user closes the query, it sometimes leaves their lock on the spreadsheet until they exit the DB. This query opens only the spreadsheet (no other tables) and extracts just the data needed for the DB to make the data more user friendly. I have checked the query to see if it is editable, and it is not. Is there a way to make the link to the spreadsheet read-only (which I thought was the default)? If not, is there a way to make the spreadsheet read-only in the query?

    Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you dont want the spreadsheet locked, then import the data to an internal table.

  3. #3
    klnlsu is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    107
    Quote Originally Posted by ranman256 View Post
    if you dont want the spreadsheet locked, then import the data to an internal table.
    That was the answer (and I think the form actually loads and updates a little faster to boot).

    Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-29-2016, 09:59 AM
  2. Replies: 1
    Last Post: 08-14-2015, 12:01 PM
  3. Convert Excel Spreadsheet
    By ajay_psingh25 in forum Access
    Replies: 3
    Last Post: 07-30-2014, 01:56 PM
  4. Accessing OLE Excel file
    By cbh35711 in forum Programming
    Replies: 0
    Last Post: 04-17-2012, 09:00 AM
  5. Replies: 2
    Last Post: 07-01-2010, 07:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums