Set up MS Access client with SQL server on computers connected via a hub with no domain
Posted on 2014-12-21
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?