我这样写 错误提示为 未定义类型 adodb.Recordset
Dim con As adodb.Connection
Dim rs As adodb.Recordset
Set con = New adodb.Connection With con
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\mydb.mdb;Jet OLEDB:Database Password =;Persist Security Info=False"
.Open
End With 'con.CursorLocation = adUseClient strSql = "insert into gs values('" & dirName & "')"
Set rs = con.Execute(strSql)
Dim con As adodb.Connection
Dim rs As adodb.Recordset
Set con = New adodb.Connection With con
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\mydb.mdb;Jet OLEDB:Database Password =;Persist Security Info=False"
.Open
End With 'con.CursorLocation = adUseClient strSql = "insert into gs values('" & dirName & "')"
Set rs = con.Execute(strSql)
Set rs= New Recordset
.
.
.
set rs=new adodb.reocrdset
工程->引用->Microsoft ActiveX Data Objects 2.X Library
.
.
.
set rs=new adodb.reocrdset
偶关注这个:
回复人: viena(维也纳nn-实心木头人) ( ) 信誉:1
信誉1,怎么做到的?
Set con = New adodb.Connection
With con
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\mydb.mdb;Jet OLEDB:Database Password =;Persist Security Info=False"
.Open
strSql = "insert into gs values('" & dirName & "')"
.Execute strSql
.Close
End With
Set con = Nothing