[cherosoullis]

I have created a VB2005 application which uses an Access database which in on a server in the network which require username and password. On Windows XP I can use it just fine without requiring user name and password because I have allready provided this at the beggining. On Windows 2000 an error popups with problem connecting to the server because it cannot loging to the server without providing username and password like Windows XP. Can I configure my application to enter user name and password if required only?
(/Public con As New OleDb.OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0;Data Source = \\server1\Testing.mdb;"))

Thanks in advance.

[Jayman]

You can specify the user name and password in the connection string in the following manner. Just replace MyDbUserName and MyDbPassword, with your user name and password.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server1\Testing.mdb;User Id=MyDbUserName;Password=MyDbPassword;