Question

VB连接ACCESS数据库 提示对象变量或WITH变量未设置

请大家帮忙 谢谢~!
Private Sub Form_Load()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=app.path & \db1.mdb"
conn.Open cnstr
SQL = "select * from 个人资料"
rs.Open SQL, conn
End Sub

运行是 提示conn.Open cnstr 对象变量或WITH变量未设置
请问是什么原因啊~!
还是不行
rs.open sql,conn,adopenkeyset,,,adlockoptimistic提示
错误的参数号或无效的属性赋职

Answer 1

rs.open sql,conn,adopenkeyset,,,adlockoptimistic
还有，，有没有忘记引用microsoft activex data objects 2.6 library