473,395 Members | 1,720 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,395 software developers and data experts.

Microsoft Access 2003 Record-Locking File doesn't close

I have an ASP .NET 2003 application that uses an Access 2003 database.
Trimming my application down to just one page that connects to the database
and uses an OleDbDataReader to get info, then closes the Reader and then the
Connection, I still get the .LDB Record-Locking file staying open on the
server. Does ASP .NET not close it's connection even after the code closes
the connection??

The server is Windows 2003

(Application does work fine on all pages, mostly just REAL annoying because
I have to call the hosting company to re-start IIS services on the server
any time I change the database. And since this is a project in development,
almost every time I talk to my client I'm having to change the database
also.)
Nov 19 '05 #1
1 2390
Not sure, but you might want to force garbage collection to see if that
clears the hold on it.
"Jay A. Moritz" <ja********@hotmail.com> wrote in message
news:ud**************@TK2MSFTNGP09.phx.gbl...
I have an ASP .NET 2003 application that uses an Access 2003 database.
Trimming my application down to just one page that connects to the database
and uses an OleDbDataReader to get info, then closes the Reader and then
the Connection, I still get the .LDB Record-Locking file staying open on
the server. Does ASP .NET not close it's connection even after the code
closes the connection??

The server is Windows 2003

(Application does work fine on all pages, mostly just REAL annoying
because I have to call the hosting company to re-start IIS services on the
server any time I change the database. And since this is a project in
development, almost every time I talk to my client I'm having to change
the database also.)


Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Sean C. | last post by:
Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...
4
by: Brian Andrus | last post by:
Ok. I upgraded to MS Access 2003 recently and now I am having great heartache. In Access 2002, when I opened a table to view the data, there were wonderful little "plus" signs that I could click...
1
by: Del | last post by:
We have a MS SQL Server 2000 application for our shipping system. We have created a front end application using MS Access for our order analyst. The front end application allows the analyst to...
7
by: tpers | last post by:
How can I convert a datetime value (i.e. now()) to Greenwich Mean Time(GMT) in Microsoft Access 2003? I have an Access database that is shared by a few people across different time zones. The...
2
by: finlaymcmillan | last post by:
I tried converted an application that started life in Access 97 and is currently in Access 2003. The performance in Access 2007 of the main tabbed form has degraded considerably moving from...
16
by: google | last post by:
In a continuous form the following code is under a button in the form header. In Access 2003 and earlier, this goes to a new record, then adds relevant data to that new record. DoCmd.GoToRecord...
3
by: getro | last post by:
Hi Everyone, I need to open an Access 2003 form to a specific record from a custom Outlook 2003 Appointment form. The form has a command button that would pass a record id to access and open the...
5
by: Ben | last post by:
Hi! I have a trigger created for Customer table. My front-end is access. What is the best approach to handle a trigger result when adding a new customer record? Below is the trigger script:...
12
by: tekctrl | last post by:
Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access 2002 Issue; Access presents a blank data entry form in the Forms view when the New Record icon is used. However, it...
4
by: jay123987 | last post by:
Morning / Afternoon / Goodday All, I was hoping someone can help me in understanding the best way to attach files to a access 2003 form. I have a database which is used to log phone calls and...
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: 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
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
jinu1996
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...
0
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...
0
tracyyun
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...

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.