Results 1 to 6 of 6
  1. #1
    cebrower is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    74

    Network connection interrupted


    I recently upgraded from Win 7 Pro to Win 10 Pro. Ever since then I get a message that my network connection has been interrupted and I need to close the database and re-open it. This message appears when I click the Save button while working on any object in design view, so my work is not saved. I'm using Access 2010 working with split databases. It happens 4 or 5 times per day with all of the 4 databases that I manage. I have 20 other users that I want to upgrade to Win 10, but I want to resolve this issue before I do that. Any suggestions?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,333
    do you have the BE attached as linked tables?
    I have this and never get network interrupts. Does the PC loose the connection?

  3. #3
    cebrower is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    74
    Yes the BE is attached as linked tables. This only happens while working in Access and only since I upgraded to Win 10.

  4. #4
    Shadow9449 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Feb 2017
    Posts
    20
    By any chance, is the workstation going idle? There is a Windows setting that will put the network adapter into sleep mode if the computer is idle. So, I'm thinking that perhaps updating to Win 10 changed that setting rather than it being something inherent to Win 10.

  5. #5
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,382
    presume you are also hardwired to the location of the back end - if using a wireless connection you will get drops occasionally

  6. #6
    cebrower is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    74
    Solved. The drive map policy must be set to update, not restore. In Win 10, if it is set to restore, the connection is dropped momentarily. This is not true in Win 7. When I upgraded from 7 to 10, the policy was not changed from restore to update during the upgrade process.
    Last edited by cebrower; 07-29-2020 at 02:49 PM.

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

Similar Threads

  1. Refresh Database if Connection to File Location is Interrupted
    By TheKillerMonkey in forum Programming
    Replies: 3
    Last Post: 02-27-2019, 01:00 PM
  2. Network Connection Interruted
    By Bouler in forum Access
    Replies: 4
    Last Post: 07-26-2018, 10:16 AM
  3. Your Network Access was Interrupted
    By nharing in forum Misc
    Replies: 2
    Last Post: 09-21-2016, 04:22 PM
  4. Replies: 3
    Last Post: 08-20-2015, 10:31 AM
  5. Network Access Interrupted
    By abrogard in forum Access
    Replies: 2
    Last Post: 07-06-2012, 05:28 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 - Senior Forums