Delete access .mdb problem
Posted on 2003-03-27
In deleting .mdb file, I found that sometimes error occur:
Is it because I have a corresponding .ldb file that keep some resources that the .mdb file is not allowed to delete?
I have tried to wait until it disappear after I disconnect the database.
If Dir(App.path & "\Database\" & appFileName & ".ldb") <> "" Then
Do While True
MsgBox "xx.ldb fading out..."
DoEvents: Sleep 5000
If Dir(App.path & "\Database\" & appFileName & ".ldb") = "" Then Exit Do
But the .ldb never disappear!
What can i do?
1.Is my deduction correct, or is there any other points I have missed out?
2. And can first delete the .ldb file and then .mdb file? Please give me a sound solution ....