recordset.movefirst“无法重新启动行集位置”-recordset.movefirst“Rowsetpositioncannotberestarted”

2  

There is usually no reason to MoveFirst if you have not previously navigated the record set.

如果您之前没有导航过记录集，则通常没有理由使用MoveFirst。

The overflow is unrelated to the database code and is caused by rs!ID not fitting in a VBA integer (16 bit) so make temp a Long instead (32 bit) and remove MoveFirst.

溢出与数据库代码无关，并且由rs！ID不适合VBA整数（16位）引起，因此将temp设置为Long（32位）并删除MoveFirst。

0  

Make sure you are not using a forward-only recordset. Recordsets are this way by default. Instead use a dynamic (adOpenDynamic) or static (adOpenStatic) cursor type.

确保您没有使用仅向前记录集。默认情况下，记录集是这种方式。而是使用动态（adOpenDynamic）或静态（adOpenStatic）游标类型。

You may also need to set CursorLocation = adUseClient.

您可能还需要设置CursorLocation = adUseClient。

Finally, check for BOF before calling MoveFirst.

最后，在调用MoveFirst之前检查BOF。

Example:

例：

...
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM MyTable"
...

If (Not rs.BOF) Then
    rs.MoveFirst
End If

0  

You can use MoveFirst for forward only recordset ONLY when you are at EOF. Tricky, undocumented, but WORKS!!!!

您只能在EOF时使用MoveFirst转发记录集。棘手，无证，但工作!!!!