[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

Access timer error

I have an app that has a timer and it runs overnight. I get an error "Network access was interrupted" (see attached image). How can I code around this to stop the application crashing?
Access-error.bmp
0
HKFuey
Asked:
HKFuey
  • 2
  • 2
  • 2
1 Solution
 
PeteEngineerCommented:
(Typical disclaimer for editing the registry applies here... I do not endorse it, make a back up first, etc... :-)

 

"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters\autodisconnect"

was f (15) changed it to FFFFFFFF (4294967295)
0
 
mbizupCommented:
Alternatively, if you have a file on your network drive such as the back-end of your database that should always be there, you *may* be able to apply a test like this to determine if the network connection is available before executing any code that requires a connection:

If Dir("s:\YourFolder\YourDB_Backend.accdb") & "" = "" Then
     ' Network is down
      Exit Sub ' Or Exit Function
End if   

Open in new window

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
HKFueyAuthor Commented:
Hi Mbizup,
I'm going to try your suggestion, if it runs OK overnight you get the points!
0
 
HKFueyAuthor Commented:
It has run reliably now for a fortnight! mbizup you are Fab!!
Andy
0
 
mbizupCommented:
Glad that's worked out for you :)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now