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