title: Unable to connect Access to SQLlite via ODBC
body: <p>I have an Access 97 database that serves as a front-end, via ODBC and linked tables, to a MySQL database, running under Wiin7-64. (Yes, it does work!) The database contains info about places of worship and pilgrimage in the part of France where I live. In addition, I have tens of thousands of photos of the sites in Photoshop Elements 9. The underlying database engine of PSE9 is SQLite, and interesting data about the photos is there (titles, which ones I like, etc.). I would like to link from Access to the tables in the SQLite database as I do to the MySQL database.</p>
  
  <p>My problem: I am unable to create an ODBC connection to the PSE9 SQLite database. I have done multiple searches via Google, read multiple posts at stackoverflow and elsewhere, tried various suggestions, and still no ODBC connection, neither in the 32bit or 64bit ODBC tools of Win7-64. I'm stumped.</p>
  
  <p>So far, I've</p>
  
  <ul>
  <li>downloaded sqliteodbc.exe from <a href="http://www.ch-werner.de/sqliteodbc/" rel="nofollow">http://www.ch-werner.de/sqliteodbc/</a> and run it (multiple times)</li>
  <li>copied sqlite3odbc.dll, sqlite3.def, sqlite3.dll, and sqlite3.exe to the \windows\system32 folder</li>
  <li>entered this command at the Windows command line: "rundll32 c:\windows\system32\sqlite3odbc.dll,install", which produced this error message "Copy c:\windows\system32\sqlite3odbc.dll to c:\windows\system32\sqlite3odbc.dll failed."</li>
  </ul>
  
  <p>When I look at the ODBC and ODBC (32-bit) windows, I don't find a User DSN, System DSN or File DSN for SQLite.  Any suggestions?</p>
  
  <p>Thanks,
  Harvey in balmy Bordeaux </p>