473,387 Members | 1,891 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Cannot connet to access database vs2003


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
2 2104
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...
9
by: =?Utf-8?B?RnJpdHo=?= | last post by:
Hi all, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: ======= The...
1
by: =?Utf-8?B?VGVycnk=?= | last post by:
Hi, I am a newbe here and am working through some books on using ADO.Net. These database books were writen for VS2003. I have both VS2003 andVS2005. In VS2003 all works fine. Right click 'Data...
6
by: =?Utf-8?B?VGVycnk=?= | last post by:
When I asked this question before, don't think I was showing up as an MSDN subscriber, so I hope that is fixed now. I am a newbe here and am working through some books on using ADO.Net. These...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.