Closing an ODBC connection opened by TransferDatabase?? HELP ME!

[Webrookie]

Ok, Here's my quandry:<br><br>I have an <b>ODBC Visual Foxpro driver system DSN</b> pointing to a directory where the file I want to import is.<br><br>In <b>Access 2000</b>, I use the <b>TransferDatabase method</b> 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 <b>delete the Foxpro file</b>.&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;<u>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</u>.&nbsp;&nbsp;Is there a way of doing this without closing access?<br><br>Thanks in advance...

 

[JimHorton]

Most odbc drivers will keep a connection open even after you've explicitly closed it.&nbsp;&nbsp;Some may have an option that will fully close it, but most don't (that I know of).&nbsp;&nbsp;IBM's Client Access odbc drivers, for instance, specifically state that the machine must be rebooted to truly close the connection to the as/400.&nbsp;&nbsp;It's not good news for your case, but that's the way it is as I understand it.<br>--Jim

 

[Webrookie]

Well that stinks.&nbsp;&nbsp;Thanks for the info. though.&nbsp;&nbsp;At least I know there's no hope. &nbsp;&nbsp;I guess I don't have it that bad, I don't have to reboot the pc entirely.&nbsp;&nbsp;<br><br>Thanks,<br><br>Rookie of the Web (WebRookie)