hi VB Master, I'm building an application using VB6, MS Access 2003 as database, and crystal report ocx for printing and report.
Right now I'm using ms dao (database files) to connect crystal with access. But it is very slow, when I want to show 1 record out of 1000, the rpt load all 1000 record first before filtering.
I need help if someone know how to tell crystal to load only records I want to see.
I tried to convert database driver using OLEDB, that work, crystal only load records I want to see, but when I proceed into my other report I received error messages says there is no files ... bla bla... and I can't use some of my queries.
any help would be appreciated. thanks.