1,453
社区成员
发帖
与我相关
我的任务
分享DataGrid控件 error 7004，行集合不能作为标签。何解
程序如下
dim conn As ADODB.Connection
set conn = New ADODB.Connection
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & "abc.mdb;password =abc"
Dim sqr As String
Dim show_rs As New ADODB.Recordset
sqr = "select * from table1
show_rs.Open sqr, conn, adOpenDynamic, adLockPessimistic
Set DataGrid.DataSource = show_rs
set show_rs = NoThing
问题出在Set DataGrid.DataSource = show_rs
这一行，如何解决请教高手
dim conn As ADODB.Connection
set conn = New ADODB.Connection
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & "abc.mdb;password =abc"
Dim sqr As String
Dim show_rs As New ADODB.Recordset
sqr = "select * from table1
show_rs.Open sqr, conn, adOpenDynamic, adLockPessimistic
Set DataGrid.DataSource = show_rs
set show_rs = NoThing
问题出在Set DataGrid.DataSource = show_rs
这一行，如何解决请教高手
...全文
请发表友善的回复…
发表回复
001chb 2001-07-09
- 打赏
- 举报
同意楼上！
连接ACCESS数据库都要这样！
否则recordsetcount=-1
连接ACCESS数据库都要这样！
否则recordsetcount=-1
tmxk 2001-07-09
- 打赏
- 举报
在conn.Open前加上conn.CursorLocation = adUseClient
yuanyingtanxi 2001-07-09
- 打赏
- 举报
refurbish
