title: How do you link a sql server to Microsoft Access?
body: <p>I need to create a front end interface for my database.  I am using sql server 2014 and need to link it to Microsoft access 2016.  Please note that the two applications are on separate machines.  So far I have created a a file DSN on the machine with sql server and the connection was successful.  Within access I used the ODBC database tool to attempt to use the dsn I created to connect to the server.  I received an error sql state '08001' sql error:-1 as seen in <a href="http://i.stack.imgur.com/L6MxO.png" rel="nofollow">this image</a>.  how can I solve this issue?</p>