| DAO | ADO | |
DBEngine | n/a | |
Workspace | n/a | |
Database | Connection | |
Recordset | Recordset | |
| Dynaset-type | Keyset | Retrieves a set of pointers to the records in the recordset. |
| Snapshot-type | Static | Both retrieve full records, but a Static recordset can be updated. |
| Table-type | Keyset with adCmdTableDirect option. | |
Field | Field |
dim db as database
dim rs as dao.recordset
set db = currentDB()
set rs = db.openRecordset("tab")
…
rs.edit
rs("fld") = "changed value"
rs.update
dim rs as new adodb.Recordset
rs.open "tab", currentProject.connection, adOpenKeySet, adLockOptimistic
…
rs("fld") = "changed value"
rs.update