While designing a report you add the database to the report if the database is access and use the fields in the report

from Vb5 you just pass the selectonformula or the formulas to the report and run the report by saying crystalreport.action = 1 or some other method

which database are u using?

I could not understand what your problem is. Eloborate your question

Be clear about table remains open