none
MS Access Not Responding while checking offline folder RRS feed

  • Question

  • When I check for availability of a network file or I try to connect to the Biometric Device that we use to record attendance with fingerprint, everything works fine, but when the folder that contains the file mentioned is offline or the Biometric Device is powered off, MS Access stops responding for a while until the error message appears.

    The problem is: if the user clicks anywhere while the "Not Responding" is there, the app crushes.

    so the user has to wait until the error message appears and not touching anything before that.

    Is there any method to prevent MS Access from "Not Responding" during that process?

    Note: I use VBA and MS Access forms.


    • Edited by A.G Qassim Sunday, November 3, 2019 1:52 PM
    Sunday, November 3, 2019 1:51 PM

All replies

  • I don't think so. This is a synchronous process so the calling app, be it Access or any other, has to wait until the call returns. This can be a somewhat fragile state. I'm still surprised a single mouse click would crash Access; that should not happen.

    -Tom. Microsoft Access MVP

    Sunday, November 3, 2019 6:12 PM
  • You will need to check to see if the file is currently available and the device is active first before anything else happens. Then if either is not active or available, exit the routine and display an error message telling users the system is unavailable at this time. The checks need to be performed when the application is opened. Application crashes such as these can also leave a .laccdb lock file open which normally is automatically deleted when ACCESS is closed. Look is the directory where the application resides to make sure no locking file is showing. If it is, just delete it.
    Sunday, November 3, 2019 8:49 PM
  • Thank you for the reply,

    Well, it does happen only when the desired location is offline.

    Sunday, November 3, 2019 9:07 PM
  • Look over http://www.devhut.net/2017/08/17/vba-file-exist/ it may offer an idea to try.

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, November 3, 2019 11:07 PM