AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, September 10, 2009

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.

Labels:

Saturday, September 05, 2009

How to use .NET assembly in VBA

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

Labels: ,