Let me back up. DAO naming is hierarchical in nature, sort of
like the DOS path. And like DOS, you can refer to an object
using a fully qualified name or a semi-qualified name. In DOS, a
fully qualified name would be like this: If you are already in a
folder, you can refer to the file by its semi-qualified name:
TEST.MDB In the same way, you can refer to an Access object by
its fully qualified name: or if you assume the default DBEngine
(which we almost always do), the default Workspace, and default
Database, you can refer to the table by its semi-qualified name:
If you look at the fully qualified name like this: you can see
the DAO hierarchy levels more easily and how the dot separates
them. (Much like the "\" in DOS.) The dot also serves to
separate an object from its properties and methods, which can
also be thought of as another level in the hierarchy. So I can
refer to "TableDefs!Table1.RecordCount". RecordCount being a
property of Table1. The bang (!) separates objects from the
collections which hold th