Hi,

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.


Khoi Nguyen

__________________
Khoi Nguyen

hi there..

I my memory don't fail, the connection is not closed untill all the recordset that are opened are closed. The connection doesn't close that objects by itself.. So maybe you have a recordset opened somewhere (maybe a grid or a combo or something??)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi,

Thanks for your response. Unfortunately, I only have one recordset associated with that ADO connection. I had successfully closed that recordset before I closed the ADO connection object. Closing the ADO connection did not give me any errors, so I assumed that it worked.

Not sure where I went wrong, or if I'm missing anything here. I really appreciate any help possible.

Thank you very much.

Khoi Nguyen

I don't have a clue them... maybe the file need some time to be released???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi,

I have to revive this old post that did a while back. Yes, the file actually needs time to release. I have confirmed this. It would take several minutes for the file to be completely released before it can be accessed again.

Does anyone here know if a trick to speed up the release of a DBF file?

I would really appreciate your help.

Thanks.

__________________
Khoi Nguyen