Though most often a database object is used to refer to the database in which the code resides, there nonetheless is functionality to open a different database.
Having done that, you can use that database object to refer to all of the objects in the external database with exactly the same syntax you would use to reference local
objects if the database object referred to the local database. You can open recordsets on the tables and queries in the other db, create and delete tables and such.
Set db = DBEngine(0).OpenDatabase("C:\Path\DB.mdb", _
where BoolExclusive and boolReadOnly are variables of your own (not built-in constants) reflecting the way in which you want to open the external database.