Error - Could not start transaction; too many transactions already nested

  • Follow


using access2007 runtime
sometimes this function reports the error shown in the subject line
it doesn't use transactions, so I'm confused ?
the reports don't have any VBA and are based on queries returning 3000
rows, any idea what I should look for ?

Public Sub openReport(strReport As String, Optional strWhere As String
= "")
    On Error GoTo fErr
    DoCmd.openReport strReport, acViewPreview, , strWhere
    DoCmd.RunCommand acCmdZoom100
    DoCmd.Maximize
fExit:
    On Error Resume Next
    Exit Sub
fErr:
    If (Err <> 2501) Then
        errorLog "openReport " & strReport
    End If

    Resume fExit
End Sub
0
Reply lesperancer (740) 10/15/2010 11:40:08 AM


0 Replies
916 Views

(page loaded in 0.03 seconds)

Similiar Articles:







7/20/2012 9:18:33 PM


Reply: