ADO错误捕获
请问,当我试图捕获一个ADO错误(我是用连接一个不存在的.mdb文件来产生错误的)时,为什么VB并没有跳到Handle那行,而是在.Open处产生了实时错误?
On Error GoTo Handle
Dim cnnConnection As ADODB.Connection
Set cnnConnection = New ADODB.Connection
With cnnConnection
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data.mdb"
.Mode = adModeReadWrite
.CursorLocation = adUseClient
.Open
End With
On Error GoTo 0
Exit Sub
Handle:
MsgBox Err.Description