Could not display data

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()
 
Y

yma

Hi,

I am the administrator. I can open the nwind.mdb in Access. I can use code
the load the data. I cannot use the data controls to load the data.

Sal said:
Check if aspnet user has enough rights on the folder that contains the
database mdb file.
Sal

yma said:
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()
 
S

Sal

Check if aspnet user has enough rights on the folder that contains the
database mdb file.
Sal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top