Hi Team,



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=\\199.102.54.20\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.

Raam

You cannot set the remote computer's username and password in the database connection string. This is for the database itself and not for the remote computer.



Save yourself alot of headaches and use SQL Server instead for your remote database.



Have a look at this, http://social.msdn.microsoft.com/Forums/en-US/c866d0d9-9361-4aca-9131-b8c233057f12/how-to-connect-remote-access-database-from-vbnet?forum=Vsexpressvb

Destroyer