datagrid绑定recordset出错：The Rowset is not bookmarkable!??

[DBIverson]

如题。
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\lab.mdb; Persist Security Info=False"
cnn.Open
Set rc = New ADODB.Recordset
rc.Source = "Select * from Animals"
Set rc.ActiveConnection = cnn
rc.CursorType = adOpenDynamic
rc.Open
Set DataGrid1.DataSource = rc

[muxinqionghuo1980]

Set rc = New ADODB.Recordset

加上一句：rc.CursorLocation =adUseClient

然后你在试试

[yhic]

rc.Source = "Select * from Animals"
改为rc.open "Select * from Animals" 试试！

[kongyunzhongque]

对要有这句:rc.CursorLocation =adUseClient

[haipingma]

Set rc = New ADODB.Recordset
rc.Source = "Select * from Animals"
Set rc.ActiveConnection = cnn
rc.CursorType = adOpenDynamic
rc.LockType=adLockOptimistic '加上這句
rc.Open
Set DataGrid1.DataSource = rc

[yoki]

rc.open之前加上rc.CursorLocation =adUseClient

[射天狼]

rc.CursorLocation = adUseClient
rc.Open "Select * from astuff", cn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rc

有你写的那么麻烦吗？这样就行了!!

[lgs666]

把动态游标该为静态的:
rc.CursorType = adOpenDynamic
改为:
rc.CursorType=adOpenStatic

[DBIverson]

谢谢大家。关键还是cnn.type=adUseClient。
To cuizm(射天狼)：
　　我在一个连接可能要打开很多个recordset，所以还是要显式定义连接。不知道对不对？