Edit

Convert DAO code to ADO

  • Article

Applies to: Access 2013, Office 2013

Note

Versions of the DAO library prior to 3.6 are not provided or supported in Access.

DAO to ADO object map

DAO

ADO (ADODB)

Note

DBEngine

None

Workspace

None

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

When referred to in a recordset.

DAO

Open a Recordset

 Dim db as Database
 Dim rs as DAO.Recordset
 Set db = CurrentDB()
 Set rs = db.OpenRecordset("Employees")

Edit a Recordset

 rs.Edit 
 rs("TextFieldName") = "NewValue"
 rs.Update

ADO

Open a Recordset

 Dim rs as New ADODB.Recordset
 rs.Open "Employees", CurrentProject.Connection, _
         adOpenKeySet, adLockOptimistic

Edit a Recordset

 rs("TextFieldName") = "NewValue" 
 rs.Update

Note

Moving focus from current record via MoveNext, MoveLast, MoveFirst, MovePrevious without first using the CancelUpdate method implicitly executes the Update method.

About the contributors

Link provided by the UtterAccess community. UtterAccess is the premier Microsoft Access wiki and help forum.