代码如下:可是运行到标"*"处时,总提示类型不匹配,初次使用 DAO ,实在没看明白问题出在那里,请高手指点!!!Function preconnect()
Dim mydb As Database, myset As Recordset, connectstr As String
'On Error GoTo preconnect_err
If Dir(App.Path + "/erp.mdb") = "" Then
MsgBox "没有找到本地数据库 erp.mdb ,请检查!", 48, "出错提示"
End If
Set mydb = DBEngine.Workspaces(0).OpenDatabase(App.Path + "/erp.mdb")
******Set myset = mydb.OpenRecordset("select dbuser_id,dbpass_id,dsn from dbuser")
myset.MoveLast
……
Dim mydb As Database, myset As Recordset, connectstr As String
'On Error GoTo preconnect_err
If Dir(App.Path + "/erp.mdb") = "" Then
MsgBox "没有找到本地数据库 erp.mdb ,请检查!", 48, "出错提示"
End If
Set mydb = DBEngine.Workspaces(0).OpenDatabase(App.Path + "/erp.mdb")
******Set myset = mydb.OpenRecordset("select dbuser_id,dbpass_id,dsn from dbuser")
myset.MoveLast
……
——已经引用了 DAO 3.51