Delete .ldb by force on network

Hi: Is there any way by which i delete by force .ldb from network and then open the database. Some times i have problem with the database as i check by means of going to each desk and see if the database is open or not and even no one is using the database but it still shows the .ldb file and not allow me to do any changes in the database.

Thanks.
mustish1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MNelson831Connect With a Mentor Commented:
Create a form.  Call it watchdog or whatever.  Add code to the on open event of your main form that will open the new form. Something like this:

Private sub MainMenu_Open()

Docmd.Openform "Watchdog"

Forms.Watchdog.visible = false
me.setfocus

End sub

0
 
MNelson831Connect With a Mentor Commented:
Sometimes the ldb file will remain even when no one is using it.  In these cases, the file is deletable.  When the file cannot be deleted, then someone has a live connection to it.

What I have done in a similar situation is to code a default form that opens when the datbase opens, but is not visible.  the on timer event of this form contains code that looks a value in a linked table.  In my application, it was a yes no field named SCAT.  The VBA logic in each user application read something like this:

If SCAT = true then docmd.quit

I set the timer to every 60000 milliseconds (1 minute).  Then all I have to do to evict all the users is update MyTable set SCAT = True and then wait 30 seconds
0
 
MNelson831Connect With a Mentor Commented:
and then wait 30 seconds <<60 seconds I mean
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
mustish1Author Commented:
The default form in my database is mainmenu. How to i create another default form. 2nd how to i hide that form.
0
 
mustish1Author Commented:
Another thing i check physically by means of going to each desk to check if somen one is open the database but no one has the open the database. Then i try to delete the .ldb file but its not allow me to delete and give message that some one is in the database.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
There are known issues with this - at times you must either (a) drop to a command prompt and attempt to delete the ldb file or (b) reboot the machine, then delete the ldb file. In many cases, (a) won't work, only (b) will ...
0
 
sublimationConnect With a Mentor Commented:
Hi, mustish1.

You can simple contact the network admin team and ask them to delete it for you (they will have the privileges).

0
 
sublimationConnect With a Mentor Commented:
Hi, mustish1.

Also, if you right-click the ldb file, and send to notepad, it will give you a list of all the users connected to the database.

Ed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.