I'm currently writing a VB6 app that needs to access a Visual FoxPro DB (a file with the extension .DBF). I'm using ADO to connect to it just fine.
However, I have one problem which is I need to release the connection within my VB
app, when needed. Basically, I have tried to close the ADO recordset, and then close the ADO connection object to the DBF file, but some how, that's not enough to release it. I have another app that I need to call to archive this DB, and it refuses to do so, and it keeps saying that the file is in used, but within my own VB6 app, I have already closed all connection to it.
Is there any way that I can get around this? I really need to terminate the connection to the DBF file, without having to shut down my app, because I also launch the archiving app from within my VB
app so I cannot shutdown my app.
Any help is very much appreciated. Thank you very much for your time.