Converting DAO Code to ADO

Office 2013 and later

Last modified: July 28, 2015

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

Task

DAO

ADO

Open a Recordset

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

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

Edit a Recordset

rs.Edit 

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

rs("TextFieldName") = "NewValue" 

rs.Update

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

Link provided by: Community Member Icon The UtterAccess community

UtterAccess is the premier Microsoft Access wiki and help forum. Click here to join.