Binding control error 
Author Message
 Binding control error

Hi,

I'm tring to bind a dropdownlist on a webform with a colomb from a
Access2000 table
Everything goes well untill I try to fill the dataset, then I get an error.
It says that the access mdb file is already open or that i do not have the
rights.

I already checked the permission, and the mdb file has not been opened by
something else

Can anyone help me with this, tnx.

Server Error in '/CoolApp' Application.

----------------------------------------------------------------------------
----

The Microsoft Jet database engine cannot open the file 'P:\Mijn
Documenten\Visual Studio Projects\CoolApp\CoolApp.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 'P:\Mijn Documenten\Visual Studio
Projects\CoolApp\CoolApp.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.

Source Error:

      Line 40:         ' Create a dataset object and fill with data using
data adapter's Fill method

      Line 41:         Dim ds As DataSet = New DataSet()

      Line 42:         da.Fill(ds, "RepairPerson")

      Line 43:         ' Attach dataset's DefaultView to the dropdownlist
control

      Line 44:         Dim dv As DataView =
ds.Tables("Employees").DefaultView

Source File: c:\inetpub\wwwroot\CoolApp\Stek.aspx.vb    Line: 42

Stack Trace:

      [OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file 'P:\Mijn Documenten\Visual Studio
Projects\CoolApp\CoolApp.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)

         CoolApp.WebForm1.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\CoolApp\Stek.aspx.vb:42

         System.Web.UI.WebControls.Button.OnClick(EventArgs e)

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument)

         System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)

         System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

         System.Web.UI.Page.ProcessRequestMain()

----------------------------------------------------------------------------
----

Version Information: Runtime Build:1.0.2914.16; ASP.NET Build:1.0.2914.16



Sat, 27 Mar 2004 23:31:36 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Errors when quitting a form with a required bound control

2. Binding Data Control errors

3. Undocumented error with Data Bound Controls

4. Bound controls with DAO 3.51 and VB5 - detect duplicate errors

5. Error 91 when trying to bind an ADO Recordset to an MSFlexGrid Control

6. Bound TextBox Control Error

7. Field not Updateable error using bound data control

8. Error with checkbox control bound at design time

9. Error 91 when trying to bind an ADO Recordset to an MSFlexGrid Control

10. Data-bound Masked Edit makes all data-bound controls not display data

11. Access 97 bound or not ot bound controls

12. How do I bind columns from several tables to one bound control in VB 5.0

 

 
Powered by phpBB® Forum Software