Access 2007 - force deleting files in use by other applications.
Posted on 2011-02-28
I've got a situation in an Access 2007 application where users can import files as attachments to different business objects. When a user chooses to they can open that object and view it, which actually opens the file in whatever application is associated with it. If the user then tries to delete that file through the Access application interface then they receive an error stating that the file cannot be deleted because it is already in use by another application.
Is there any way to force delete files through Access VBA regardless of the fact that they may be locked by other applications?