Access 'project' Versus 'database'

I seem to be missing an understanding of the difference between a project and a database. I am using a .mdb and writing code with success until I try to use the recordset feature which I took from my "VBA programming" book.

My code is simple...

Dim db As Database
Dim rec As Recordset
Dim strSQL As String
Dim intCount As Integer
Dim listEmails As String

strSQL = "SELECT Email from Member"

db = CurrentDb()
rec = db.OpenRecordset(strSQL, dbOpenSnapshot)

Do Until rec.EOF
listEmails = listEmails & Chr$(10) & rec(Email)
Loop

rec.Close

MsgBox listEmails

But when I run it I get a compile error because in line 1 the term 'database' is only a class in "a project".

Can anyone explain the issue and better still the solution.

Thanks

Phill