两句程序：
set recorders=dbfaccount.openrecordset("orders",dbopentable)
Set recselect = dbfbiblio.OpenRecordset(strsql, dbOpenSnapshot)
注：strsql是一个SQL查询的字符串变量
dbopentable与dbOpenSnapshot分别代表什么意思
dbopentable是直接打开表,后面直接对表操作,另外一个是快照型记录集的方式打开,后面相当于操作表的一个影子
dbOpenTable
Opens a table-type Recordset object (Microsoft Jet workspaces only).
dbOpenDynamic
Opens a dynamic-type Recordset object,
which is similar to an ODBC dynamic cursor. (ODBCDirect workspaces only)
dbOpenDynaset
Opens a dynaset-type Recordset object, which is similar to an ODBC keyset cursor.
dbOpenSnapshot
Opens a snapshot-type Recordset object, which is similar to an ODBC static cursor.
dbOpenForwardOnly
Opens a forward-only-type Recordset object.

滴滴