<div>
<div class="content wysiwyg-content">
I have always built ms access clients linked to a SQL server backend on a network with a domain. &nbsp;I have a potential client who does not have a domain network setup but a couple of pcs connected via a hub. &nbsp;They have a computer identified to be the server and this too is connected to the hub. &nbsp;<br />
<br />
Can I still set up an MS Access client pointing to a SQL server backend on this network. &nbsp;I am sure this can work but need confirmation and the SQL connection string format.<br />
<br />
Below is the string format I currently use<br />
Public Const connstring = &quot;Provider=SQLOLEDB;DRIVER=<wbr />SQL Server;SERVER=&quot; &amp;&nbsp;serverip &amp;&nbsp;&quot;;UID=&quot; &amp;&nbsp;usernamewrite &amp;&nbsp;&quot;;PWD=&quot; &amp;&nbsp;passwordwrite &amp;&nbsp;&quot;;DATABASE=SQLDatabase;enc<wbr />rypt=true&quot;<wbr /><br />
<br />
Will the string above still work or will it have to be altered?
</div>
</div>


I have always built ms access clients linked to a SQL server backend on a network with a domain.  I have a potential client who does not have a domain network setup but a couple of pcs connected via a hub.  They have a computer identified to be the server and this too is connected to the hub.  

Can I still set up an MS Access client pointing to a SQL server backend on this network.  I am sure this can work but need confirmation and the SQL connection string format.

Below is the string format I currently use
Public Const connstring = "Provider=SQLOLEDB;DRIVER=SQL Server;SERVER=" & serverip & ";UID=" & usernamewrite & ";PWD=" & passwordwrite & ";DATABASE=SQLDatabase;encrypt=true"

Will the string above still work or will it have to be altered?

Set up MS Access client with SQL server on computers connected via a hub with no domain

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.

Microsoft 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.