By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Cannot connet to access database vs2003

P: n/a

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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.