Hi all,
I am trying to browse a table in my MS Access DB
from a web form, using a bound datagrid. The DB
is populated, and the grid in on the web form. When
I execute the following code:
daDrawings.Fill (DsDrawings1.tb lDrawing)
daIssue.Fill(Ds Drawings1.tblIs sue)
DataGrid1.DataS ource = DsDrawings1.tbl Drawing
DataGrid1.DataB ind()
I get the following error: The Microsoft Jet database engine cannot open the file 'C:\Documents
and Settings\jason\ My Documents\Visua l Studio
Projects\Casca des\myDB.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.Ole Db.OleDbExcepti on: The Microsoft Jet
database engine cannot open the file 'C:\Documents and
Settings\jason \My Documents\Visua l Studio
Projects\Casca des\myDB.mdb'.I t is already opened exclusively by
another user, or you need permission to view its data.
Source Error:
Line 154: 'Put user code to initialize the page here
Line 155:
Line 156: daDrawings.Fill (DsDrawings1.tb lDrawing)
Line 157: daIssue.Fill(Ds Drawings1.tblIs sue)
Line 158:
I am using a typed dataset. I have set the permission on the folder
that contains the MDB file and the access permissions to the file
itself for the Internet Guest Account on my machine and yet I still
get this error. The DB doesn't appear to be open.
Does anyone know what might be going wrong?
Many thanks,
Jason. 2  1366 
Hi Jason,
Are you using IIS? If so, have set up the application correctly in IIS? To
check this, go into IIS, view the properties on the web application, view
the Home Directory tab and see if the Application Protection is set to
Medium or High. If the Unload button to the right is enabled, click it. It
usually mean that IIS has kept the application open and it is this that
could be still using the Access file.
Another check that you could do is attempt to move it from that location to
see if it is really in use by anything.
Are you using the Application or Session objects to store open connections
.... yuck?! If so, you'll need to tidy the code up. When linking Access to
web forms, it is always good to use disconnected data, this way, the main
source remains free for anyone (authorised) to use.
Hope this helps.
Landers
"Jason L James" <ja***@nospam.d ivemaster.org> wrote in message
news:1l******** *************** *********@4ax.c om... Hi all,
I am trying to browse a table in my MS Access DB
from a web form, using a bound datagrid. The DB
is populated, and the grid in on the web form. When
I execute the following code:
daDrawings.Fill (DsDrawings1.tb lDrawing)
daIssue.Fill(Ds Drawings1.tblIs sue)
DataGrid1.DataS ource = DsDrawings1.tbl Drawing
DataGrid1.DataB ind()
I get the following error:
The Microsoft Jet database engine cannot open the file 'C:\Documents
and Settings\jason\ My Documents\Visua l Studio
Projects\Casca des\myDB.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.Ole Db.OleDbExcepti on: The Microsoft Jet
database engine cannot open the file 'C:\Documents and
Settings\jason \My Documents\Visua l Studio
Projects\Casca des\myDB.mdb'.I t is already opened exclusively by
another user, or you need permission to view its data.
Source Error:
Line 154: 'Put user code to initialize the page here
Line 155:
Line 156: daDrawings.Fill (DsDrawings1.tb lDrawing)
Line 157: daIssue.Fill(Ds Drawings1.tblIs sue)
Line 158:
I am using a typed dataset. I have set the permission on the folder
that contains the MDB file and the access permissions to the file
itself for the Internet Guest Account on my machine and yet I still
get this error. The DB doesn't appear to be open.
Does anyone know what might be going wrong?
Many thanks,
Jason.
Landers,
I think it was folder security that sorted it in the end. The
parent of the parent of the folder where the MDB file was
stored did not grant access to the guest account.
All seems fine now.
Thanks,
Jason.
On Tue, 9 Nov 2004 21:47:17 -0000, "Landley"
<ne**@creatio ns-software.co.uk> wrote: Hi Jason,
Are you using IIS? If so, have set up the application correctly in IIS? To
check this, go into IIS, view the properties on the web application, view
the Home Directory tab and see if the Application Protection is set to
Medium or High. If the Unload button to the right is enabled, click it. It
usually mean that IIS has kept the application open and it is this that
could be still using the Access file.
Another check that you could do is attempt to move it from that location to
see if it is really in use by anything.
Are you using the Application or Session objects to store open connections
... yuck?! If so, you'll need to tidy the code up. When linking Access to
web forms, it is always good to use disconnected data, this way, the main
source remains free for anyone (authorised) to use.
Hope this helps.
Landers
"Jason L James" <ja***@nospam.d ivemaster.org> wrote in message
news:1l******* *************** **********@4ax. com... Hi all,
I am trying to browse a table in my MS Access DB
from a web form, using a bound datagrid. The DB
is populated, and the grid in on the web form. When
I execute the following code:
daDrawings.Fill (DsDrawings1.tb lDrawing)
daIssue.Fill(Ds Drawings1.tblIs sue)
DataGrid1.DataS ource = DsDrawings1.tbl Drawing
DataGrid1.DataB ind()
I get the following error:
>The Microsoft Jet database engine cannot open the file 'C:\Documents
>and Settings\jason\ My Documents\Visua l Studio
>Projects\Casca des\myDB.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.Ole Db.OleDbExcepti on: The Microsoft Jet
>database engine cannot open the file 'C:\Documents and
>Settings\jason \My Documents\Visua l Studio
>Projects\Casca des\myDB.mdb'.I t is already opened exclusively by
>another user, or you need permission to view its data.
>Source Error:
>Line 154: 'Put user code to initialize the page here
>Line 155:
>Line 156: daDrawings.Fill (DsDrawings1.tb lDrawing)
>Line 157: daIssue.Fill(Ds Drawings1.tblIs sue)
>Line 158:
I am using a typed dataset. I have set the permission on the folder
that contains the MDB file and the access permissions to the file
itself for the Internet Guest Account on my machine and yet I still
get this error. The DB doesn't appear to be open.
Does anyone know what might be going wrong?
Many thanks,
Jason. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: J |
last post by:
Hi,
Ive got 3 forms, (a subform within a subform within a form) and when I
refresh the outermost form, Access closes and offers to send an error
report.
The forms worked fine a few weeks ago, but now they cause this error
in Access 2002 (Access 2000 is fine)
Each of the sub forms use values from their parent forms to produce
results.
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
I'm wondering what are the disadvantages of using Access as front-end? Other
that it's not...
|
by: Olav.NET |
last post by:
I am a .NET/C++ developer who is supposed to do some work with Access.
I do not know much about it except for the DB part.
Questions:
*1*
I am looking for INTENSIVE books to get quickly up to speed.
I like books with practical exercises, and also with test questions (like
cert books)
*2*
|
by: Deano |
last post by:
Hi,
I have a finished Microsoft Access app that we are distributing using an
Access runtime. This works fine (mostly) but I'm sold on the advantages of
dot.NET and upgrading to vb.NET seems like a good idea for the future. I'm
also keen to develop new software in vb.NET as soon as possible.
I will work out how to port the app and how to use ado.NET etc, however I'm
not certain about all the things I need to consider hence the...
|
by: dbuchanan |
last post by:
I have a Windows Forms application that accesses SQL Server 2k from a
small local network. The application has been used for weeks on other
systmes but a new install on a new machine retruns errors.
The machine is a new laptop Windows XP Pro SP2
The machine is up to date with respect to the dot net framework.
Details:
Dot Net Framework ver. 1.0.3705 is installed
Dot Net Framework ver. 1.1.4322 is installed
| | |
by: Jordan S. |
last post by:
SQL Server will be used as the back-end database to a non trivial client
application.
In question is the choice of client application:
I need to be able to speak intelligently about when one client (MS Access vs
..NET Windows Forms) would be preferred over the other. While I have some
good arguments on both sides, I would appreciate your points of view on the
topic.
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.
It also seems impossible to open the library in another Access instance
|
by: Bob Alston |
last post by:
I am looking for electronic forms software that would integrate well
with MS Access.
I have a client for whom I built a client database to replace and update
one they had that was obsolete and not doing what they want.
They are wanting to move on to the next step and automate most of their
forms. some are boilerplate forms that are simple printed without
change. some are boilerplate but require signatures from client and
rep. Others...
|
by: Chad |
last post by:
Hi
Is it possible to substitute an alternative data source (eg MySQL or
SQL Server) into an existing MS-Access application?
|
by: Wesley Peace |
last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having
with visual studio 2008.
I've created a series of forms with controls to access a Access database
tables. The connection string works fine and the tables are added to the
project without a problem.
When I create the tables they appear to bind and I am able to preview the
data in the database in design mode; however, at runtime no data is
displayed and the...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
