I'm modifying some code which uses the FileSystemObject to check a folder and image path then sets the .Picture property of an Image control accordingly. This happens in the OnCurrent event of a form.
I closed the form and tried to rename the folder in windows explorer to check my error catching but get a message saying the folder is in use.
This is what I'm doing
Declaring it: Dim FSO As Scripting.FileSystemObject
Setting new before use: Set FSO = New Scripting.FileSystemObject
Used to check folder exists: If FSO.FolderExists(strExamFolder) Then 'do something
Used to check image exists: If FSO.FileExists(strImageIncPath) Then 'do something
before exiting: Set FSO=Nothing
Any ideas why my db is hanging on to the folder?