PC Review


Reply
Thread Tools Rate Thread

Database still locked after user closes application.

 
 
david
Guest
Posts: n/a
 
      13th Nov 2008
A registry entry on the server that can affect this behaviour:

HKLM\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\ Parameters\
DormantFileLimit

Determines how many files on each share can remain open in the redirector's
cache after an application has closed them. If the number of open, cached
files on a share exceeds the value of this entry, the system begins to close
the cached files.

Also
AutoDisconnect
Determines how long a client will remain connected if idle. If the client
breaks the connection instead of closing, this setting is one which
determines how long the server will have to wait before scavenging broken
file connections.
Conversely, this may effect a live database connection over lunch: I don't
know about that. Default value is 10-15 minutes. The least of the
client-server setting breaks first, the matching client setting is
KeepConn

(david)


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
OleDBConnection Closes executes but leaves the Access database locked doni@ti.com Microsoft ADO .NET 1 11th Apr 2007 10:52 PM
Accidentally locked access database application =?Utf-8?B?TGVSb3k=?= Microsoft Access 2 5th Dec 2005 09:09 PM
User has locked himself out of database Stephanie Microsoft Access Security 3 2nd Jan 2004 05:54 PM
Detecting when user closes application or database John C. Microsoft Access VBA Modules 1 6th Dec 2003 10:52 PM
Re: Database locked by user Admin Joan Wild Microsoft Access Security 0 29th Jul 2003 10:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:49 AM.