+ Reply to Thread
Results 1 to 3 of 3

Excel Data connection to Access database restricts exclusive access to database

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    139

    Excel Data connection to Access database restricts exclusive access to database

    My excel spreadsheet populates a table based on a query in an access database. I've setup the connection and everything seems to be working fine with the exception that whenver the excel workbook is open, access behaves as if it is also open. I am prevented from making key changes in Access as if someone else was in the database at the same time. I've verified for sure that the issue is related to my excel spreadsheet. When I close the spreadsheet, access returns to it's normal state and I'm able to make changes again. I suspect that excel establishes a link with access to keep the data updated as long as it remains open.

    I wonder if it would be possible to modify this link so that excel would query access only once per instance that it is open and then terminate the connection. When I look under Data on the excel ribbon and then click connections I'm able to find what appears to be settings for my connection that may do what I'm trying to accomplish but I'm not sure how / what to modify. This is what it looks like currently:

    Please Login or Register  to view this content.
    Thanks for any suggestions

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,244

    Re: Excel Data connection to Access database restricts exclusive access to database

    This link may help, although I haven't tried it.


    http://www.amphis-software.com/share...s-database.htm


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: Excel Data connection to Access database restricts exclusive access to database

    hmmm, I made the recommended changes:

    Please Login or Register  to view this content.
    But I'm still being locked out of the access database every time I access the excel form.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1