Using DAO, you can have more than one database open in Access at any time. If you're using an Access .mdb, you already have one database open (called the current database). Using the Workspace object's OpenDatabase method, as shown in the example in section on Using Transactions, you can open more than one database, and operate on them under the same workspace context. Indeed, if you were to define more than one Workspace object, you could have several databases open, each operating under a different workspace context. The choice is yours. The Databases collection contains and manages these databases.
Was this article helpful?