By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 986 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Error when connecting to Microsoft Access db

P: n/a
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(I nt32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvid er() at
System.Data.OleDb.OleDbConnection.Open() at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line
118System.InvalidOperationException: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.OleDb.OleDbConnection.SetStateExecutin g(OleDbCommand attempt,
String method, Boolean flag) at
System.Data.OleDb.OleDbCommand.ValidateConnectionA ndTransaction(String
method, Int32& localState) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line 132

Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default...b;en-us;316675


"VB Programmer" <gr********@go-intechN0SPAM.com> wrote in message
news:O8*************@TK2MSFTNGP09.phx.gbl...
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(I nt32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvid er() at
System.Data.OleDb.OleDbConnection.Open() at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line
118System.InvalidOperationException: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.OleDb.OleDbConnection.SetStateExecutin g(OleDbCommand attempt,
String method, Boolean flag) at
System.Data.OleDb.OleDbCommand.ValidateConnectionA ndTransaction(String
method, Int32& localState) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line 132


Nov 18 '05 #2

P: n/a
Thanks!

"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default...b;en-us;316675


"VB Programmer" <gr********@go-intechN0SPAM.com> wrote in message
news:O8*************@TK2MSFTNGP09.phx.gbl...
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(I nt32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvid er() at
System.Data.OleDb.OleDbConnection.Open() at
LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line
118System.InvalidOperationException: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.OleDb.OleDbConnection.SetStateExecutin g(OleDbCommand attempt, String method, Boolean flag) at
System.Data.OleDb.OleDbCommand.ValidateConnectionA ndTransaction(String
method, Int32& localState) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) at LatLongTest.EmailNotification.GetEmailRecipients() in
c:\inetpub\wwwroot\LatLongTest\EmailNotification.a spx.vb:line 132

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.