delete images from a folder 1

[waely]

hi,
I need some help please. when I insert a record in my access db I insert the path for the image related to this record. these images are located in "upload" folder. how can I delete these images when I delete the related records from my access.

thanks for advance for any help.

 

[cmmrfrds]

FSO can be used to manipulate the directory structure.


Function FSOExampleDelete()
'-- Reference Library
'-- Microsoft Scripting Runtime Libarary
Dim objFSO As Object
Set objFSO = CreateObject("Scripting.FileSystemObject&quot
Dim filename As String
filename = objFSO.GetFileName("C:\AEmptyDir\Test2.rpt&quot
Debug.Print "------- my file ---------"
Debug.Print "File Name = "; filename

If objFSO.FileExists("C:\AEmptyDir\Test2.rpt&quot Then
'---Delete the file.
objFSO.DeleteFile ("C:\AEmptyDir\Test2.rpt&quot
Else
Debug.Print "The file to delete does not exist. "; filename
End If

Set objFSO = Nothing

End Function