I have developed a rating project using VB.net and MS Access.
My database have no password and it is saved in on the LAN remote computer with username and password protected.
I have tried giving username and password of the shared desktop in the connection string , but it doesn't worked.
let say the shared computer username is "admin", and password is "welcome"
Public con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\126.96.36.199\ABC\CDE\XYZ_Database.mdb;Persist Security Info=False;")
All the users have to poll there result and cannot shared the remote computer username and password to all.
Need help to get me a VB.net code.