Solved

Delete ldb file

Posted on 2011-09-21
9
382 Views
Last Modified: 2012-06-21
Hi,

I have a DB running on a distance. Via remote desktop i can mange this DB. Now the hasn't logoff. I have to install a new version of the DB with another versionnumber and i need to remove the old frondend, but the lock-file is still there.
Is there a way to remove this file?

Tx
0
Comment
Question by:sonmic
  • 5
  • 3
9 Comments
 
LVL 75
ID: 36575879
I assume you have not been able to Delete it?

Rebooting the computer that houses this db should clear out the LDB file.  Is that an option ?

mx
0
 
LVL 75
ID: 36575897
Also, I've found this to be quite useful:


http://www.filehippo.com/download_unlocker/

(Free)

If you can install it on the remote system and run it, you may ... be able to kill the process(s) that is holding onto the LDB file (probably MSACCESS.EXE).

mx
0
 
LVL 57
ID: 36575898

 If you can't reboot, you'll need to clear the file handle.  If this is through a share, then it's easy.  If not, it gets a little harder.  Details here:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22423758.html

Jim.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 36575926
the LDB file should automatically be deleted when Access closes normally.  The fact that it is still there, implies:

1.  Someone is using the file - you should not be able to delete the file if the associated mdb or accdb is still in use
2.  Access terminated abnormally - you should be able to just delete the file.

If you are unable to simply delete it, and you are certain that the application is not in use by anyone, use Task Manager to check the computer that the db is installed on to determine whether "MSACCESS" is running (either as an application or as a process).  You can use Task Manager to close the app if it is open or still running as a process, although I prefer to do as "mx" suggests and just reboot that box, if possible.

0
 
LVL 75
ID: 36575947
I think the  Unlocker program is a well, simplified version of SysInternals on steroids ... and a lot easier to use ... since it drills right down to what is holding that file open.  It's a very quick install also.

Anyway, one or more of the methods above should resolve your issue.

mx
0
 
LVL 57
ID: 36575969
@MX,

<<I think the  Unlocker program is a well, simplified version of SysInternals on steroids ... and a lot easier to use ... >>

 Do you have a link for that?  I don't believe that other thread has a link for it.  And your right, it's far simpler to use then process explorer.

Jim.
0
 
LVL 75
ID: 36576010
I posted the link in first post ...

http://www.filehippo.com/download_unlocker/

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 36576024
It's especially useful for USB thumb drives that don't seem to 'disconnect' ...

You just right click over that drive in Explorer ... select Unlocker ... and go from there.  It's shows quickly what is holding it - and you KILL it.

mx
0
 
LVL 57
ID: 36576035

 Sorry.  Hadn't seen your second post when I posted.

Jim.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question