Folks,
I am sure this is a simple one for you gurus. I am rather new to ASP.Net.
I have setup a connection string to an MS Access database using web.cfg.
Somehow, some component of ASP.Net keeps the database opened (I can see the
..ldb file) even when the user has physically logged off (session.abando n).
Ideally, I would like to achieve traditional ASP type environment, where the
connection opens only when the page is being processed.
I would appreciate your comments to fix my issue.
Thanks.
Walt.
1  1246 
WQ,
Best practise with ADONET is to open and close everytime your connection.
When you are using the dataadapter, you do not even have to create it. The
dataadapter does it for you, in that case it closes it automaticly.
For this kind of AdoNet questions is the best newsgroup.
Microsoft.publi c.dotnet.framew ork.adonet
I hope it gives some idea's
Cor
"WQ" <no*****@no-reply-mail.com>
I am sure this is a simple one for you gurus. I am rather new to ASP.Net.
I have setup a connection string to an MS Access database using web.cfg.
Somehow, some component of ASP.Net keeps the database opened (I can see
the
.ldb file) even when the user has physically logged off (session.abando n).
Ideally, I would like to achieve traditional ASP type environment, where
the
connection opens only when the page is being processed.
I would appreciate your comments to fix my issue.
Thanks.
Walt.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: deko |
last post by:
After doing a lot of vba work, I've noticed the size of my mdb has grown,
even though no data or objects have been added.
I've read that the following procedure will remedy this and improve
performance:
1. From the command line, type msaccess.exe /decompile.
2. Open the database you want to decompile.
3. Open up any module. Select the Compile All Modules and Save All Modules
menu items.
|
by: Neil Ginsberg |
last post by:
I have a strange situation using Access to automate a Word mail merge. Using
Access 2000 and Word 2000, the code opens Word, opens the document in Word,
sets a table
in the calling Access application as the data source, and then performs a
merge. Everything works fine.
However, when a user uses it in Access 2002 and Word 2002, an extra instance
of the Access application is opened and remains open at the end. Sometimes
it remains open
|
by: Terry Bell |
last post by:
We've had a very large A97 app running fine for the last seven years.
I've just converted to SQL Server backend, which is being tested, but
meanwhile the JET based version, running under terminal server, has
suddenly started running very slowly. The network engineer has thrown
up his hands and said "It's Access 97". I've checked out lots of
things including the Oplocks setting and other stuff from this NG, and
I think I've done everything...
|
by: Andy Davis |
last post by:
Has anyone come across a similar problem? A company I'm doing some database
development work for has just installed 3 copies of MS Access 2003. Whenever
I try to open my Access database (created using Access 2003) it just shows
as a blank screen with no database structure. As a test, I created a new
database with a dummy table (no data) and then closed Access. After opening
Access again I opened the new database file with dummy table and...
|
by: Ignacio X. Domínguez |
last post by:
Hi. I'm developing a desktop application that needs to store some data in a
local file. Let's say for example that I want to have an address book with
names and phone numbers in a file. I would like to be able to retrieve the
name by searching for a given phone number the fastest I can.
I have considered the posibility of using XmlTextReader with something like:
<list>
<item number="1234567">
<name>John Doe</name>
| | |
by: Jason L James |
last post by:
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.tblDrawing)
daIssue.Fill(DsDrawings1.tblIssue)
|
by: Gary |
last post by:
If you develop a stand alone c# windows application that only reads from a
single local Access database, do you need to close the connection each time
you navigate to a different record? No other person or program will ever
interact with this single table MS Access database.
I have been developing web applications where you open then close the
connection to an external datasource with each submission but this is so
different.
|
by: Mell via AccessMonster.com |
last post by:
I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.
If they have Ms Access 2000 or higher, will they be able to use these dbs
with all code, etc?
Please explain
--
Message posted via http://www.accessmonster.com
|
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access database
- containing a list of addresses.
Sequence of events is =
(1) Excel template opens in its default XXX.xls filename.
(2) Code runs to save the spreadsheet as XXX.xls.
(3) User clicks a button to open an Access database containing an
|
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 Microsoft page "How to: Connect to Data in an Access Database
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
