Crystal Report 9 Showing DAO Erro Code: 0xbe4

[DaShark]

Hello,

I am having a little problem, I developed a payroll application in VB6.0, reports in Crystal Reports 9. I packaged using installshield. These reports run ok on my system. However when tested on production systems (other systems), I get the DAO error message. I figure what the problem is just not sh\ure how to fix it.

Prob. The reports are still bound to the datasource that it was designed with, I set the datasource from code using recordset. However some strange reason the report still retain the datasource from CR9. any \one knows how to solve this please let me know.

Thanks,
Shark

[Hack]

Using bound datasources have always been nothing but problems.

Unbind it in crystal reports and do all the connecting via code.

Another way would be to make sure all computers have the exact same folder structure you used on your development machine. That is a cheesy way out but it usually works.

[DaShark]

Using bound datasources have always been nothing but problems.

Unbind it in crystal reports and do all the connecting via code.

Another way would be to make sure all computers have the exact same folder structure you used on your development machine. That is a cheesy way out but it usually works.

Thanks Hack,

I actually get it to work using the same directory structures. As you said thats a corny way out. The thing is if you remove the datasource in crystal report, all the filed names will go too. This means you would have to find a way to set up the fields, sections and groups in CR9 from VB6 code, as anyone ever done that before....?

[Hack]

This means you would have to find a way to set up the fields, sections and groups in CR9 from VB6 code, as anyone ever done that before....?

Of course we will leave the question out in the open, but I would venture to say no...that would be a lot of work and I'm not sure the return would be worth it.