Hello I have a vb.net application with MS access database.
I want to run LAN in 3 pc by this application.
So it possible or which SQL method shuold I adopt for LAN connectivity.
I started to convert my database in SLQ express but I am not succeed .
can i make LAN connectivity in Home Group?
I require one pc as database server and any of the three pcs can retrive and update database on LAN.
So would it be possibel by LAN in MS access database connecting by Home Group(the link you provided)
Yes, you will need to network the computers together to be able to reach the server computer.
1)Connect the computers to a router
2)Create the database on the server
3)Create a share and store the database there
3)Set connection string in application (See [this](http://www.connectionstrings.com))
4)Make sure that the server computer is on and accessible
The database path for the server will be something like:
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...