OLE DB Connections

When I try to connect to a MS Access database an exception occurs that tells me that "the datafile is either already opened exclusive by another user or you don'y have permission to access the data". This occurs on my computer - I'm developing an application in Visual Studio.net- not on a remote server. The file in question has been set to shared access and is not open at the time the connection attempt is made. Any suggestions?where is your database?if it's under intepub folder then change it's location like c:\mydatabase\yourfile.mdb .It will solve your problem
Arvind
Hi,

does the aspnet_user account on your machine have write permissions on the folder where your access database resides?

Grz, Kris.
I've tried both suggestions and still no luck. I've also tried to connect with the Nothwinds database example by placing it in a variety of directories and I can't connect to it either. This is what I get:

Server Error in '/DBid' Application.
------------------------

The Microsoft Jet database engine cannot open the file 'C:\dbidmaster.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\dbidmaster.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Source Error:

Line 128: Dim dr As OleDb.OleDbDataReader
Line 129:
Line 130: OleDbConnection1.Open()
Line 131: dr = OleDbCommand1.ExecuteReader
Line 132:

Source File: c:\inetpub\wwwroot\DBid\Login.aspx.vb Line: 130

Stack Trace:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file 'C:\dbidmaster.mdb'. It is already opened exclusively by another user, or you need permission to view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
DBid.Login.btnSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\DBid\Login.aspx.vb:130
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
I think your *.mdb file was opened by the Microsoft Office Access
or, in your code you may not close the DataReader or the Connections last time