<div>
&quot;Best way&quot; is a vague term...<br />
;-)<br />
<br />
Have you tried:<br />
External Data--&gt;Import--&gt;More--&gt;ODB<wbr />C
</div>


"Best way" is a vague term...
;-)

Have you tried:
External Data-->Import-->More-->ODBC

<div>
Good point although the answer also seems a little vague! &nbsp;I don't have ODBC under the 'More' menu although there is an ODBC icon next to 'More' (I have Access 2010). &nbsp;<br />
<br />
So once in ODBC... what next?
</div>


Good point although the answer also seems a little vague!  I don't have ODBC under the 'More' menu although there is an ODBC icon next to 'More' (I have Access 2010).  

So once in ODBC... what next?

<div>
Please confirm that you can login to your SQL Server from your remote workstation. (or is your question about networking rather than applications?)
</div>


Please confirm that you can login to your SQL Server from your remote workstation. (or is your question about networking rather than applications?)

untitled.JPG

<div>
<i>what is the best way of achieving this?</i><br />
The best way is using code. &nbsp;But I suspect this is not what you want to hear.
</div>


what is the best way of achieving this?
The best way is using code.  But I suspect this is not what you want to hear.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I need to connect an access front end to a sql server back end on a remote server - what is the best way of achieving this?<br />
<br />
Ken
</div>
</div>


Hi

I need to connect an access front end to a sql server back end on a remote server - what is the best way of achieving this?

Ken

Connecting ms access fron end to remote sql server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.