1 of my procedures creates a temp directory (c:\TempImportDb) in which I put a copy of empty tables, import some data, and do some stuff. At the end I want to delete the temp database (kill statement which works fine) and then delete the temp directory (RmDir which does not work at all). I do:
Dim dbPathDir As String
dbPathDir = "C:\TempImportDb\"
If fIsFileDIR("C:\TempImportDb\", vbDirectory) = True Then
I am getting error 75, "Path/File access error". Seems like access thinks that the file is still being used. I also tried the ChDir command befor the RmDir but no joy. Any ideas?
Any advice would be appreciated