Access 2013 Loop Through Recordset

[xljunkie]

I keep getting error messages when using

Dim rs as DAO.Recordset
Set rs = Currentdb.OpenRecordset("tblClients")
rs.MoveFirst
Do Until rs.EOF = True
     'Code
Loop
Set rs = Nothing

I assume this is because I'm on Access 2013 and in my references Microsoft DAO 3.6 is unchecked, and when I check it, I get an error in loading the DLL. What is the solution to this issue? Do I need to save the db as an .mdb rather than my current .accdb format? I wanted to keep the accdb format in order to have nicer looking forms/graphics, but it's not needed.

 

[Micron]

It can be dangerous to make such assumptions! Especially when things aren't working as intended...

Well, it was a question, no?