Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Delete .ldb by force on network

Posted on 2006-10-30
8
Medium Priority
?
1,606 Views
Last Modified: 2010-10-13
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.
0
Comment
Question by:mustish1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 15

Assisted Solution

by:MNelson831
MNelson831 earned 1000 total points
ID: 17838087
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
 
LVL 15

Assisted Solution

by:MNelson831
MNelson831 earned 1000 total points
ID: 17838092
and then wait 30 seconds <<60 seconds I mean
0
 

Author Comment

by:mustish1
ID: 17838112
The default form in my database is mainmenu. How to i create another default form. 2nd how to i hide that form.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Comment

by:mustish1
ID: 17838137
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
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 total points
ID: 17838349
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
 
LVL 4

Assisted Solution

by:sublimation
sublimation earned 600 total points
ID: 17842398
Hi, mustish1.

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

0
 
LVL 4

Assisted Solution

by:sublimation
sublimation earned 600 total points
ID: 17842432
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
 
LVL 15

Accepted Solution

by:
MNelson831 earned 1000 total points
ID: 17842443
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

721 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