title: Multiple databases in MS Access VBA?
body: <p>This Microsoft <a href="http://support.microsoft.com/kb/113701" rel="nofollow">KB article</a> details how to run a query on another database than the current one used by the Access project. However it only states how to connect to DBase, Foxpro, Paradox, BTrieve and ODBC.</p>
  
  <p>I want to be able to do something like this:</p>
  
  <pre><code>UPDATE MSSQLDatabase.Table
      SET MSSQLDatabase.Table.Column = AccessDatabase.Table.Column
      WHERE MSSQLDatabase.Table.Column = AccessDatabase.Table.ID
  
  INSERT INTO AccessDatabase.Table
      VALUES (AccessDatabase.Table.ID)
  </code></pre>
  
  <p>Can you give me any pointers of where to begin? The database I want to connect to is a SQL Server 2008 Provider Native connection. I'm using Access 2007.</p>
  
  <p>To do this in VBA would be perfect.</p>