hi all:)

i am using vb6 and msaccess.i have to search the data in database from various table and write into text files.

iam using recordset concept,its takes 2 hours to write data.

iam want to reduce time because data are in lacs...

please help for best solution..

thanks in advance

hi there.. how much data are you writing?? maybe the problem is in your code??

can we see a little of what are you doing, there is a lot of things you can do to speed up a process, but it's depends on the process itself...

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
================================================== =========