dbTalk Databases Forums  

Lock File Issue - 2007

comp.databases.ms-access comp.databases.ms-access


Discuss Lock File Issue - 2007 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John von Colditz
 
Posts: n/a

Default Lock File Issue - 2007 - 03-05-2010 , 08:40 AM






Strange issue with lock files. Database is split front end with
multiple back ends. When users log out of the database, the following
situation occurs.
User(s) log out
If One User In Database Then
Lock File Gone in < 1 Sec
Else
Lock File Persists Up to 30 Minutes!
Endif

This morning a lock file did persist for > 30 minutes, and no one could
start the database during that period of time.

Any suggestions would be greatly appreciated!

John

Reply With Quote
  #2  
Old   
Br@dley
 
Posts: n/a

Default Re: Lock File Issue - 2007 - 04-12-2010 , 11:19 PM






On Mar 6, 12:40*am, John von Colditz <johnv... (AT) earthlink (DOT) net> wrote:
Quote:
Strange issue with lock files. Database is split front end with
multiple back ends. When users log out of the database, the following
situation occurs.
User(s) log out
If One User In Database Then
* * Lock File Gone in < 1 Sec
Else
* * Lock File Persists Up to 30 Minutes!
Endif

This morning a lock file did persist for > 30 minutes, and no one could
start the database during that period of time.

Any suggestions would be greatly appreciated!

John
I think we need more info on the environment.
eg. How many backends? Where are they located? Where is the front-end
located?

Br@dley

Reply With Quote
Reply




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.