Private Sub Form_Load() On Error Goto ErrHandler: Dim Conn As New ADODB.Connection Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ="+App.Path+"/Db/myForm.mdb" MsgBox Conn.State '数据库连接状态 ErrHanler: If Err Then Msgbox Err.Description,VbOkOnly,"错误" End If End Sub
On Error Goto ErrHandler:
Dim Conn As New ADODB.Connection
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ="+App.Path+"/Db/myForm.mdb"
MsgBox Conn.State '数据库连接状态
ErrHanler:
If Err Then
Msgbox Err.Description,VbOkOnly,"错误"
End If
End Sub