title: Run-Time error '-2147024703 (800700c1)' when running Access 2010 with SQL Server 2008
body: <p>I have an application written in MS ACCESS 2007 using VBA, connecting to an SQL Server at the back end. Both Access and SQL Server are running locally.
  My machine runs Access 2010 and MS SQL Server Express 2008 R2 (both 32-bit, on WinXP) with no problem.</p>
  
  <p>I have another machine, Win7 64-bit, running both Access 2010 and SQL Server 2008 (NOT R2) 64-bit.</p>
  
  <p>When I run the Access application on the 64-bit machine, I have a drop down box to select the SQL Server which holds the various databases. When I select the server, after a few seconds I get an error:</p>
  
  <blockquote>
    <p>Run-time error '-2147024703 (800700c1)':</p>
    
    <p>Automation error %1 is not a valid Win32 application.</p>
  </blockquote>
  
  <p>When I select the Debug option, the yellow arrow points to:
  <code>Set oServer = New SQLDMO.SQLServer</code></p>
  
  <p>The next line is:
  <code>oServer.Connect ServerName, strSQLUser, strSQLPwd</code></p>
  
  <p>In the watch list, I can see that <code>ServerName</code>, <code>strSQLUser</code>, and strSQLPwd hold the right values to access the SQL Server. I've tested these in sqlcmd and successfully was able to query tables.</p>
  
  <p>Can anyone please help me out on this one? I'm not sure what to do next.</p>