troubleshooting Question

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

Avatar of RDLFC
RDLFC asked on
Microsoft SQL ServerMicrosoft Access
1 Comment1 Solution177 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros