Error when connecting to Microsoft Access db

[VB Programmer]

I get an error when I connect to my mdb. I know for sure that I dont have
it open and that the path is correct.

Here's the error:

System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\wwwroot\MyTest\MyDatabase.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvider() at
System.Data.OleDb.OleDbConnection.Open() at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.aspx.vb:line
118System.InvalidOperationException: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.OleDb.OleDbConnection.SetStateExecuting(OleDbCommand attempt,
String method, Boolean flag) at
System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String
method, Int32& localState) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.aspx.vb:line 132

 

[Ken Cox [Microsoft MVP]]

Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

 

[VB Programmer]

Thanks!

Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675