Cannot delete directory after creating it

[Guest]

I have code in several places that creates directories and I’ve noticed
several times that after I’m done testing and try to delete the directories,
I get the following error message:

"Cannot delete xxx: It is being used by another person or program.

Close any programs that might be using the file and try again."

The code I’m using is simple:

If Dir(RetreivePath & "\Invoice\", vbDirectory) = "" Then
MkDir (RetreivePath & "\Invoice\")
End If

Maybe I have to close something out in code, but I can’t figure it out. Any
suggestions would be much appreciated.

Thanks,
Clint

 

[Alex Dybenko]

Hi,
if you do export there or something like this - then this could a reason
for such error message. What is the reason to delete it after creating?
else - could be some background process - indexing for example.


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Hi there. Sorry for not being more detailed. I'm running code to test the
creation of folders and then delete them when I'm done testing. The deletion
is manual, but I suspect that trying to delete the folder via code will
result in the same error.

Deleting folders will be an option for my users when I release the DB, so it
is possible that someone could create a folder by mistake and want to delete
it very soon after creation.

Also, eventually the folders in question are "released" and can be deleted.
I believe every time I've closed Access down in my testing, I could
immediately delete the folders. It seems that the hold up is related to
Access.

Thanks!

 

[Alex Dybenko]

Well, don't know for sure why this happens, but try to either do some other
file operation, which will probably release just created folder

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[bob]

Another option is to run this utility (wholockme) on a file within the
folder to see what is going on:

http://www.dr-hoiby.com/WhoLockMe/

If the folder is on a Windows server there are built-in ways of seeing that
info also.

Bob

 

[DAVID]

Check that you haven't left a file open.

If you put a database there, check that you haven't
left a database open.

Turn off the BackGround Inteligent Transfer Service
on your PC (the 'BITS' service).

If that doesn't help, turn off drive caching in the
hard drive properties.

If that doesn't help, check your permissions.

There is nothing in the code shown that would indicate
a problem.

(david)