How do I close an ODBC connection opened by TransferDatabase?

[Webrookie]

Ok, Here's my quandry:<br><br>I have an ODBC Visual Foxpro driver system DSN pointing to a directory where the file I want to import is.<br><br>In Access 2000, I use the TransferDatabase method to import the file for me to process.<br><br>That all works fine.&nbsp;&nbsp;I process it...everything is great.<br><br>As part of clean up, I dynazip the foxpro file and then I want to delete the Foxpro file.&nbsp;&nbsp;It won't let me, it says the file is in use.&nbsp;&nbsp;I can't open the file, nor delete it manually.&nbsp;&nbsp;I have to exit out of access to do anything with it, which leads me to believe that when I exit access, the odbc connection is closed.&nbsp;&nbsp;Is there a way of doing this without closing access?<br><br>Thanks in advance...