asked on
Set up MS Access client with SQL server on computers connected via a hub with no domain
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=
Will the string above still work or will it have to be altered?
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=
Will the string above still work or will it have to be altered?
Microsoft SQL ServerMicrosoft Access
Last Comment
Jim Dettman (EE MVE)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.