请VB高手看一看,问题出在哪了? 谢谢!

来源:百度知道 编辑:UC知道 时间:2024/09/24 20:31:29
公共模块(DBcontrol.bas)
Public Function getrs(ByVal strquery As String) As ADODB.Recordset
Dim rs As New ADODB.Recordset
Dim conn As New ADODB.Connection
On Error GoTo getrs_error
conn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=e:\VB程序\后台\temp\后台数据库.mdb"
conn.Open
rs.Open Trim(strquery), conn, adOpenKeyset, adLockOptimistic
Set getrs = rs
getrs_exit:
Set rs = Nothing
Set conn = Nothing
Exit Function
getrs_error:
MsgBox (Err.Description)
Resume getrs_exit
End Function
Public Sub executesql(ByVal strcmd As String)
Dim conn As New ADODB.Connection
On Error GoTo executesql_error
conn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=e:\VB程序\后台\temp\后台数据库.mdb"
conn.Open
conn.Execute Trim(strcmd)
executesql_exit:
Set conn = Nothing
Exit Sub
executesql_error:
MsgBox (Err.Descr

把On Error GoTo getrs_error 去掉,并去掉错误处理部分,在vb下运行程序,程序会停在出错的地方,这样可以缩小范围 监视一下与这一句相关的参数或设置,应该不是大问题。