Solved

Delete ldb file

Posted on 2011-09-21
9
364 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
 
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
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 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 - Access MVP) 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now