Help ASAP Need this Error Fixed!

[308holes]

why am i getting this error and how can i fix it ?

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

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

Source Error: 


Line 123:    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 124:        'Put user code to initialize the page here
Line 125:        daGuest.Fill(dsGuest)
Line 126:    End Sub
Line 127:
 

Source File: c:\inetpub\wwwroot\ClaytorsCottages\Guest.aspx.vb    Line: 125 

Stack Trace: 


[OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\ClaytorsCottages\bin\ClaytorsCottagesAccess.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)
   ClaytorsCottages.Guest.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\ClaytorsCottages\Guest.aspx.vb:125
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()

 


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

[jpfolin]

did you load .net framework before IIS or after?

[308holes]

befor

My pages run fine just when i added Database support it get that error ?

[Musician]

Well the error message is saying you have the database open exlusively. If you have it open in access then instead open access and browse to the db and open it without selecting to open it exclusively. Then you can have it open in access and test the webpage.

[Sheppe]

Access DB's can only have one connection at a time and thus are unrealistic for a web application. Try setting up your DB in SQL Server, or SQL Desktop Ed..

[Musician]

Originally posted by Sheppe
Access DB's can only have one connection at a time and thus are unrealistic for a web application. Try setting up your DB in SQL Server, or SQL Desktop Ed..

This is incorrect. Access can be shared by many users as long as none of them has it open exclusively which is an option when you browse in access and open the mdb.
Unfortunately access remembers if you had it open exclusively and if you open it from the recent list it open exclusively again so you need to explicitly browse for it and ensure you are not selecting exclusive when opening it.
Apart from that I have designed several applications in the past being used by several users on a network.

[Sheppe]

Originally posted by Musician
This is incorrect. Access can be shared by many users as long as none of them has it open exclusively which is an option when you browse in access and open the mdb.
Unfortunately access remembers if you had it open exclusively and if you open it from the recent list it open exclusively again so you need to explicitly browse for it and ensure you are not selecting exclusive when opening it.
Apart from that I have designed several applications in the past being used by several users on a network.

Curious. Do you have the code to open it without exclusive access?

[Musician]

I could be wrong but accessing an mdb through code will be default be for sharing in .net. I have only done access systems in vb6 with ado and I did it the standard way which allows several users to use my system at once. No special code involved.

[308holes]

OK gues that all was a bunch of Mubo Jumbo can some one give me a solution to my problem i dont have the file open in Access and i dont know what do doo Help ?

[Negative0]

Try moving the access database out of your web directory. The web directory has permissions on it so you cannot write data, so try moving the database to somewhere on the local C: drive.

I have found a lot of issues using Access with ASP.NET and moving the DB to a new location helps a lot.

Hope this helps,