Cannot connet to access database vs2003

Enska

I have problems connecting my access database I get information .. I
cant use my database and I'm administrator on my computer so permission
shutnot bee problem, but I dont know Where is the problem. Can enybody
help me!!!!

Server Error in '/Koulu/tietokannat' Application.
--------------------------------------------------------------------------------

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

Source Error:
Line 32: {
Line 33: // Put user code to initialize the page here
Line 34: daAsiakas.Fill(dsAsiakas1,"Asiakas");
Line 35: DataGrid1.DataBind();
Line 36: }
Source File: c:\inetpub\wwwroot\koulu\tietokannat\webform1.aspx .cs
Line: 34

Stack Trace:
[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\wwwroot\Asiakas_tietokanta.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvid er()
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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)
tietokannat.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\koulu\tietokannat\webform1.aspx .cs:34
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


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

--
Enska
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Dec 7 '05 #1

paul

In Access to make it so the default is NOT to open the database
exclusively each time:
Tools | Options | Advanced | Default Open Mode of Shared instead of
Exclusive

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

Dec 7 '05 #2

Bob Barrows [MVP]

Enska wrote:

I have problems connecting my access database I get information .. I
cant use my database and I'm administrator on my computer so
permission
shutnot bee problem, but I dont know Where is the problem. Can enybody
help me!!!!

Server Error in '/Koulu/tietokannat' Application.
--------------------------------------------------------------------------------
There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person here who
can answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.aspnet.
However, read on:
The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\Asiakas_tietokanta.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.

This identical error occurs in classic ASP as well when permissions are not
set correctly.

All users of an Access database require Modify permissions for the folder
containing the database to allow multi-user activity. Users need to be able
to create, modify and delete the locking file, Asiakas_tietokanta.ldb in
your case. Without the ldb file, the database can only be opened by one user
at a time.

So, if your site is using anonymous access, the aspnet user needs to be
granted permissions for that folder. If using Windows authentication, the
users need to be granted those permissions.

I would suggest moving the database to a folder outside of wwwroot to
prevent people from downloading the mdb file by entering its address in the
browser address box.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Dec 7 '05 #3