C#: Password protected DB connection

Commissar

I’m having trouble with a web application I’m trying to develop in c#. I can get everything working with an unsecured database but the problem arises when I try to use a password protected DB. I get the error:

“Cannot start your application. The workgroup information file is missing or opened exclusively by another user.”

Any tips or hints you could give me would be great.

connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
                                              Data Source=C:\Applications\MyApp.mdb;
                                              User ID=a;
                                              Password=b";

	if( !IsPostBack )
	{
		connection.Open();
		adapter = new OleDbDataAdapter("SELECT Productname AS Name, ProdDesc AS Description FROM Products WHERE Ordered=True", connection);
		adapter.Fill(products, "Products");
		DataGrid1.DataSource = Products.Tables["Products"].DefaultView;
		DataGrid1.DataBind();
		connection.Close();
}

Gosh

If you haven't created a Workgroup information file for your database this will explain how to do it here

bonkey

You should find what you need in this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/odatanet2.asp

Search in there for Workgroup Information File.