title: Installing PostgreSQL ODBC driver on windows 10
body: <p>I'm looking for the simplest way for Access users to connect to a PostgreSQL database. We will use it as a simple interface for updating data.</p>
  
  <p>My idea was to create an Access database with linked tables to the PostgreSQL database, and to use a file based dsn connection so that the users don't have to set up their own machine connections.</p>
  
  <p>I can set up a file based connection if I install the official driver (the 32-bit works for me), and <em>IF</em> I have the PostgreSQL database software installed as well. If I only install the odbc-drivers, I cannot create or use a file based connection, only machine based connections. It says it cannot verify the connection.</p>
  
  <p>Is this intended?</p>
  
  <p>I would rather not have to make the users install the whole database software, just to be able to connect (remotely) through Access.</p>
  
  <p>I'm using PostgreSQL 9.6.6. on a ubuntu server, and Windows 10. Have tried installing both 32 and 64 bit odbc drivers (<a href="https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_06_0500-x86.zip" rel="nofollow noreferrer">https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_06_0500-x86.zip</a>, <a href="https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_06_0500-x64.zip" rel="nofollow noreferrer">https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_06_0500-x64.zip</a>)</p>
  
  <p>Thanks for any info or suggestions!</p>