If you want to loop through the tabledefs, forms, queries and other objects you don't need to open access application, a specially if want to iterate objects in the current database. You can create query like this:
1) forms
SELECT Name
FROM MSysObjects
WHERE (Type = -32768)
2)tables and queries
SELECT Name
FROM MSysObjects
WHERE ((Type = 5) OR (Type = 6))
If you refer to DAO.xx, where xx is version of DAO (like 3.6) you can enum objects using collections of tables, queries and forms. Example for enum tables:
Sub EnumObjects()
Dim db As DAO.Database, tbl as DAO.TablDef
On Error Goto Err_EnumObjects
Set db = Currentdb
For each tbl In db.TableDefs
Debug.Print tbl.Name
Next tbl
Exit_EnumObjects:
On Error Resume Next
Set db = Nothing
Exit Sub
Err_EnumObjects:
MsgBox Err.Description, vbExclamation, Err.Number
Resume Exit_EnumObjects
End Sub