I'm working on a Windows XP box with Access 2007. I have a small issue for which I have not found a solution. After I attach a file in Access 2007, I find that I cannot delete the folder that contained the file until Access is completely closed. I can't just close the form that I used to
attach the file. I have to close Access before I can delete the folder.
The following statement is in my cmdClose_Click subroutine.
DoCmd.Close acForm, Me.Name
How do I free up memory or clear the lock on that folder after I have attached the file within the folder?
It raises a bigger question for me: What should I be doing with each form
when I close them to ensure resources are freed up?
thx,
Jim