Access timer error

Posted on 2011-10-03
Last Modified: 2012-05-12
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?
Question by:HKFuey
    LVL 8

    Expert Comment

    (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)
    LVL 8

    Expert Comment

    LVL 61

    Accepted Solution

    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


    Author Comment

    Hi Mbizup,
    I'm going to try your suggestion, if it runs OK overnight you get the points!

    Author Closing Comment

    It has run reliably now for a fortnight! mbizup you are Fab!!
    LVL 61

    Expert Comment

    Glad that's worked out for you :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now