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?
Who is Participating?
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

(Typical disclaimer for editing the registry applies here... I do not endorse it, make a back up first, etc... :-)



was f (15) changed it to FFFFFFFF (4294967295)
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.