Y
yma
Hi,
I tried to dispaly a column in MS Access 2000 nwind.mdb. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapter1.Fill(DataSet11, "employees") in page_load sub. How can I
fix it?
Thank you a lot.
Chris
Below is the message:
Server Error in '/Web420' Application.
----------------------------------------------------------------------------
----
The Microsoft Jet database engine cannot open the file
'C:\web420\Nwind.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:\web420\Nwind.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
Source Error:
Line 204: OleDbDataAdapter1.Fill(DataSet11, "employees")
Source File: c:\inetpub\wwwroot\web420\WebForm1.aspx.vb Line: 204
Stack Trace:
[OleDbException (0x80004005): The Microsoft Jet database engine cannot open
the file 'C:\web420\Nwind.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
web420.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\web420\WebForm1.aspx.vb:204
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
I tried to dispaly a column in MS Access 2000 nwind.mdb. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapter1.Fill(DataSet11, "employees") in page_load sub. How can I
fix it?
Thank you a lot.
Chris
Below is the message:
Server Error in '/Web420' Application.
----------------------------------------------------------------------------
----
The Microsoft Jet database engine cannot open the file
'C:\web420\Nwind.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:\web420\Nwind.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
Source Error:
Line 204: OleDbDataAdapter1.Fill(DataSet11, "employees")
Source File: c:\inetpub\wwwroot\web420\WebForm1.aspx.vb Line: 204
Stack Trace:
[OleDbException (0x80004005): The Microsoft Jet database engine cannot open
the file 'C:\web420\Nwind.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
web420.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\web420\WebForm1.aspx.vb:204
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()