Querying All Databases With sp_MsForEachDb

If you need to query several databases on same SQL server – you can use undocumented stored procedure sp_MsForEachDb, see Scott Mitchell article Querying a Multi-Tenant Data Architecture for more info and execution examples.

How to use .NET assembly in VBA

Example with detailed steps: Consuming .NET components within Access/VBA