Microsoft DAO 3.6 Object Library

The biggest advantage of DAO is that is very stable and also tables can be easily pre-attached (linked) within Microsoft Access.

The NEW DAO default for 2010 is ACE (Access Connectivity Engine). ACE is the Jet database engines successor and is indeed the database engine used by ACCDB/E files.

Correction: Access 2010 64-bit DOES support DAO. (Not sure about v. 3.6 but DAO is supported). Jet 4.0, DAO 3.6 and MDAC/ADO have been installed as part of the OS since Windows 2000.

Dim mSQL as string
mSQL = "select * from D_Tab"
Set db = CurrentDb()
Set rs = db.OpenRecordset(msql, dbOpenDynaset, dbSeeChanges)
do while not rs.eof
   ’’ do some updating here
   rs.edit
   rs("myfield")="123"
   rs.update
   rs.movenext
loop
rs.close
db.close

’’ ----

Dim msql As String
msql = "DELETE * FROM D_GLJournal "
msql = msql & "WHERE " & mfindgl

msql = "UPDATE K_Parameter SET K_Parameter.LValue2 = " & mDocUID

msql = "INSERT INTO D_Queue ( QDateTime) SELECT #" & Now() & "#"

DoCmd.RunSQL msql

Note: DAO 3.6 was the final version developed by Microsoft. According to Microsoft, the DAO will not be available in its future 64-bit operating systems.

Updated On: 12.12.08