connecting to ms access

[vasskereszt]

I am new to vb.net. I am trying to build a web app using an ms access back-end. I want to display a table in a datagrid. I followed step-by-step instructions in a vb.net book.
When I create the connection object and test the connection, it says "successful". But when I run the app in debug mode, the browser comes up with this error message: Server Error in '/dotnetwebapps/gyakorlas' Application.
--------------------------------------------------------------------------------

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

Source Error:


Line 168: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 169: 'Put user code to initialize the page here
Line 170: adpBooks.Fill(DsetBooks1)
Line 171: dgdbooks.DataBind()
Line 172: End Sub


Source File: C:\Inetpub\wwwroot\dotnetwebapps\gyakorlas\frmMainzs.aspx.vb Line: 170

Stack Trace:


[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file 'C:\1zsolt\FBC-Library\Db\nopw-FBC_library.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.FillFromCommand(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)
gyakorlas.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\dotnetwebapps\gyakorlas\frmMainzs.aspx.vb:170
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()




--------------------------------
From: Kristian Vass

 

[cjard]

Yeah, um.. thats a Web question and this is the WinForms area of the forums

 

[vasskereszt]

Sorry, I thought it was a data access question. My bad.

 

[JohnH]

It looks like a "data access" topic to me, but winforms and webforms development environments are very different, that why we have different forums for these here. I have moved the thread to "Data Access" forum in ASP.Net section.