error messgae

[dexbee]

Hello again,

Thak you so much for helping me with my previous issue. Now I have one last hurdle before seeing some output. I am trying to access info from a Microsoft Access db. I am using Jet 4.0 in the ODBC driver. When I run my code, I get this error message:

The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\campus.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:\Inetpub\wwwroot\campus.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Line 15: public void FillDataSet(myDataSet dSet)
Line 16: {
Line 17: oleDbDataAdapter1.Fill(dSet);
Line 18: }
Line 19:


Source File: c:\inetpub\wwwroot\aspcontrol\component1.cs Line: 17



Any ideas?

Thanx again
Danielle

[Cander]

do you maybe already have code that is opening the database twice? also make sure dont have access open viewing that database. perhaps if you post the code for the whole page we can check.

[dexbee]

Hi, thanks for your response.. here is the entire message:

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

The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\campus.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:\Inetpub\wwwroot\campus.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Source Error:


Line 15: public void FillDataSet(myDataSet dSet)
Line 16: {
Line 17: oleDbDataAdapter1.Fill(dSet);
Line 18: }
Line 19:


Source File: c:\inetpub\wwwroot\aspcontrol\component1.cs Line: 17

Stack Trace:


[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\campus.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() +131
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +98
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASPcontrol.Component1.FillDataSet(myDataSet dSet) in c:\inetpub\wwwroot\aspcontrol\component1.cs:17
ASPcontrol.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\aspcontrol\webform1.aspx.cs:26
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.209; ASP.NET Version:1.0.3705.0

Thanks again,
Danielle