Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Access 2010 step in macro fails

I have a macro in Access 2010 with several queries. One query has a ODBC connection. when the connection fails for any reason, I want to do something else. Is there a way to detect a failure of a specific query in a macro and do something if it fails or would I have to create a stand alone macro and see if the macro itself fails?

Thanks
0
LeLeBrown
Asked:
LeLeBrown
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Does this absolutely need to be done in a macro (is this a web database?)

This is easy to do in VBA.

You can trap the ODBC error in your error handler:

Sub RunQueries()

On Error GoTo Err_RunQueries

********** Your Code Goes Here **********

Exit_RunQueries:
    Exit Sub

Err_RunQueries:
    'If ODBC error
    If Err.Number = 3146 Then
        'Do Something...?
        Resume Exit_RunQueries
    Else
        MsgBox "There was an error executing the command." _
        & vbCrLf & "Error " & Err.Number & ": " _
        & vbCrLf & Error, vbExclamation
        Resume Exit_RunQueries
    End If

End Sub


But you need to be more specific on what your mysterious "Do something" means...
..as this might not be what you want.

JeffCoachman
0
 
LeLeBrownAuthor Commented:
Hi Jeff,

Thanks for the response. I ended up doing something in VBA like your example.
To explain further:
I have one query that depends on a ODBC connection that creates a Access local table. If the connection is not available (which seems to happen with some frequency), I don't want my code to stop(because it runs on its own - set up as a task in task manager). I created a macro to run this query and called it from VBA. If it fails (I don't care why), I run another macro that makes a table based on the old data copied from the previous day(that doesn't rely on the odbc conn).
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK, so if my post helped you in some way, then I am happy
;-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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