That IS the only solution. Occasionally, a FE crashes, or forgets to exit the .laccdb , and the only fix is to manually delete it.
An idea, make a vb program,(excel) that runs in the background (or server daemon, or 'phantom') and is constantly deleting the file and ignores the error.
Code:
sub On_Timer()
KillFile "//server/folder/myDb.laccdb"
end sub
Public Sub KillFile(ByVal pvFile)
Dim FSO
On Error Resume Next
Set FSO = CreateObject("Scripting.FileSystemObject")
'FileReadOnly pvFile, False
FSO.DeleteFile pvFile
Set FSO = Nothing
End Sub
a automatic timer deletes the file every minute, but if someone is in it, the delete fails. (until it doesn't)