DAO Properties in Access

Hi,

I'm using vba in Access and I want to update a table, but I don't know how to set the properties of a recordset to be anything other than read only. I'm using Access 2000. I know with ADO you can use things like adOpenDynamic, adLockOptimistic, but I don't know the DAO equivalents.

Can anyone help me please?

My code currently looks like this:

Set dbDte = CurrentDb
SQLstrDte = "SELECT Email_Date.Email_Date FROM Email_Date WHERE (((Email_Date.Email_Date)<>Date()))"
Set rstDte = dbDte.OpenRecordset(SQLstrDte) '*** need to set properties here****
If rstDte.EOF = False Then
rstDte!Email_Date = Date
rstDte.Update
Else
End If
dbDte.Close

Oops, just realised I put this in the wrong place! Sorry!