Dim Conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
If rs.State = 1 Then
rs.Close
End If
rs.Open "select * from wenyin1", DataEnvi.Conn, adOpenDynamic, adLockOptimistic
Set rs = DataEnvi.Conn.Execute("select * from wenyin1")
但是rs.Open "select * from wenyin1", DataEnvi.Conn, adOpenDynamic, adLockOptimistic 此句错误,为什么?
Dim rs As New ADODB.Recordset
If rs.State = 1 Then
rs.Close
End If
rs.Open "select * from wenyin1", DataEnvi.Conn, adOpenDynamic, adLockOptimistic
Set rs = DataEnvi.Conn.Execute("select * from wenyin1")
但是rs.Open "select * from wenyin1", DataEnvi.Conn, adOpenDynamic, adLockOptimistic 此句错误,为什么?
解决方案 »
- 请问如何模拟鼠标点击消息 使treeview的nodeclick事件发生
- 串口发送和接收ASCII码大于128的数据
- 刚才的问题解决了,现在再问一个,谢谢大家
- 请教一个思路?是否应该在在后台建一个表专门存贮菜单名?
- COM+ 代理程序导出后安装是出现失败
- 要在EXCEL打开时对SHEET1的某些数据进行检测该怎么写代码??我不懂VB请给出尽可能详细的代码,OK
- 如何解决“多步OLE DB操作产生错误”?
- 请问如何在data控件中设定什么才能连接ODBC
- recordset更新问题????
- ado连接的数据库在打包时(自带工具),需要额外添加哪些DLL文件
- 救命啊,怎么把\uXXXX 转换成汉字?
- 有谁能告诉我怎么备份sql server数据库?
不行
提示错误:
run-time error '3709'
连接无法用语执行此操作。在此上下文中它可能已被关闭或无效。
Dim rs As New ADODB.Recordsetset rs=new adodb.recordset
rs.Open "select * from wenyin1", Conn, adOpenDynamic, adLockOptimistic
Set rs = DataEnvi.Conn.Execute("select * from wenyin1")
但是用rs.Open "select * from wenyin1", Conn, adOpenDynamic, adLockOptimistic
打开是总提示错误
就是conn.Open "provider=microsoft.Jet.OLEDB.3.51:" & "Data Source=" & App.Path & "\123.mdb"
Dim rs As New ADODB.Recordsetset rs=new adodb.recordset
rs.Open "select * from wenyin1", DataEnvi.Conn, adOpenDynamic, adLockOptimistic
Set rs = DataEnvi.Conn.Execute("select * from 表名")