Results 1 to 2 of 2
  1. #1
    Travb81 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2014
    Posts
    18

    handling "Data provider returned an E_FAIL status" error with a disconnected recordset

    I have a form, in datasheet view.


    The form data source is a disconnected recordset.
    This is connected at runtime.
    It was setup this way to speed up things which has worked amazingly.

    One problem I have,... if the network connection is interrupted and the user tries to update a record, I get the error "Data provider or another service returned an E_FAIL status".
    This is a dialog box with one "OK" button.

    I'm trying to intercept this error message via the Form_Error procedure, but this is not being triggered.

    How can I detect this situation?
    If I can, I can resolve this by reconnecting the data connection without any disruption to the user.

    Thanks 🙏🙏🙏

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The error trap can stop vb code errors. It doesnt stop database system errors. (ala connections)
    Users would need to know their data is not coming and not have to sit there watching a spinning hourglass when no data is gonna arrive.

    tho, there may be an API to stop it but I doubt it.

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

Similar Threads

  1. Error Handling "System Resources Exceeded"
    By Chad Access in forum Programming
    Replies: 3
    Last Post: 06-22-2018, 04:31 AM
  2. Replies: 12
    Last Post: 02-23-2018, 05:15 PM
  3. Replies: 13
    Last Post: 12-12-2016, 12:26 AM
  4. Replies: 5
    Last Post: 10-27-2014, 07:59 PM
  5. Replies: 7
    Last Post: 08-14-2013, 03:57 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