473,671 Members | 2,221 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to unlock database

dima69
181 Recognized Expert New Member
I have an application with data on the server. Sometimes this data file remains locked even after all users exited the applcation. So the only option now is to restart the server, which is undesireble.
The question is if there is another way to unlock the data file, whithout restarting the server ?
Oct 29 '06 #1
2 40506
NeoPa
32,569 Recognized Expert Moderator MVP
First look at the LDB file (Just use Type MyDB.Ldb or whatever from the 'Command Prompt' or from 'Run') to see who has it locked.
Check carefully all entries in the list (sometimes it is open by people or PCs you wouldn't expect.
When you've cleared these all down and it still has entries (possible as it doesn't handle some crashes v well) then you need to look at unlocking the file from an OS point of view.

This gets a bit technical so hold on.
Open 'Computer Manager' from the Admin Tools folder.
If it's not stored on the local PC but a server somewhere then right-click on the top line 'Computer Management (local) and 'Connect to another computer...'. Select the server from the Browse list.
Select 'Shared Folders' then 'Open Files'.
Find the LDB file in the list then, from the right-click menu, select 'close'.
When the file is no longer in the list (F5 to refresh), delete the LDB file.

That should free it up for you.

If you get stuck on any of this then post back here explaining where and I'll try to clarify.
Oct 29 '06 #2
dima69
181 Recognized Expert New Member
Thanks, NeoPa. It works like a magic !
But, although a great improvement from restarting the server, still looking for something better. So my next questions are:
1. Is there any way to automate this process of ldb release ? It can be quite difficult to explain the customer about this computer manager thing.
2. Is it possible to do something without accessing the server directly ? The customer may not have that access.
Oct 30 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
4530
by: John | last post by:
I've got multiple threads and processes that write to same file. Before writing all threads / processes first lock part of file and then write to file. If one thread / process locks file, another threads / processes can not lock this file again. And I want that all threads / processes wait until first thread frees lock by calling FileStream.Unlock. But I do not know what code should I use that all threads / processes wait until first...
1
3196
by: deko | last post by:
Is there a way to unlock a table so a subroutine can complete? frmMain!frm0 has got a lock on a table I need to do stuff with. Error Number 3211: The database engine could not lock table 'tblRecords' because it is already in use by another person or process. I've tried this: HandleErr: Select Case Err.Number
2
3876
by: Unlock | last post by:
Greetings, Any expert able to help me to unlock the database at http://www.generate.netfirms.com/cgi-bin/to.cgi?l=res04 You will need to download the database which I have compressed into a zipped file (88MB). With the database unlocked, I could then use MS access to do customised searchings on any particular fields.
3
2449
by: m | last post by:
Hi, I'm running MySQL (5.0.18-nt) on WinXP with latest patches. I've some SQL code that generates an 'ERROR 11' in two different places depending on how the code is submitted. At the moment I'de like to find out what is causing the error, so I haven't included the code, which is quite lengthy. I'm not a MySQL (or anyother db) expert, but I've turned on isam logging and run the myisamlog utility which didn't seem to be the right
0
1464
by: Petra | last post by:
Hi! I don't know how to handle the following problem: When a User clicks on the detail view of an item, I lock the item in the database. If the user exits with clicking the cancel or ok button I unlock the item and everything works fine. But if the user exits just closing the explorer window or clicking on an other menu item in the frame, the item is still locked. I tried to load an aspx script which unlocks the item in the unload...
6
10565
by: kennthompson | last post by:
What is the best way to mirror mysql on a remote server for backup in case the local server is down?
1
3220
by: =?Utf-8?B?c3VqaXRo?= | last post by:
i created a windows service. it uses a db which attaches a mdf file. i created a installer for this service. it is installed successfully also. but the problem is while i uninstall the application,it shows an error "mdf file is being used by another process.".the lock is held by sqlserver. so i want to check like this pseudocode: if(File.IsLock("abc.mdf")) { File.UnLock(abc.mdf); }
3
3712
by: Kinnari | last post by:
Hello, My company has an access database 1997 (.mdb) that has been left behind by a previous programmer. Now, this programmer has locked this database. I can not update reports and can not read VB codes he wrote for reports. I can open back end with mdb file, but can not see reports. I tried shift key while opening database, do not work. How can I unlock database so I can modify reports? Any assistance would be much appreciated. KJ
1
4001
by: BPacey | last post by:
I have created a database that will be used among many users. In order to protect the data, I am trying to create a checkbox that can either lock or unlock the forn and subform for editing. It would also be useful if the background color of the fields changed color when locked. I have created the database in design mode and am not very familiar with VBA. Any insight would be greatly appreciated. Thanks!
0
8476
marktang
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...
0
8821
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 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...
0
8670
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 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...
1
6229
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5696
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();...
0
4407
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2812
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
2
2051
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1809
bsmnconsultancy
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...

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.