title: Anyone know the magic to connect Access 2007 to SQL Server 2008?
body: <p>I never use Access 2007 - until today.</p>
  
  <p>I want to connect to an existing SQL Server 2008 database. I have tried using:</p>
  
  <ul>
  <li>External Data ODBC option - but get DSN errror</li>
  <li>Upsizing wizard with ODBC - get an error</li>
  <li>Upsizing wizard with SNAC - get ODBC error. So that one seems a none starter :-)</li>
  </ul>
  
  <p>I have done some searching and only found others with same issue. About to do some more... but hoping one of you has the answer OTTOYH. Thanks.</p>