Sounds like a missing reference (or no reference to the DAO library).
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."
Make sure there is a reference set to the Microsoft DAO 3.6 object
An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.
For even more information, see
Please respond only to this newsgroup.
I do not reply to personal e-mail