Problem in Crystal 8.5 with Access Database

[itpro_79]

Hello,

I have developed report in crystal 8.5 using MS Access 2000. I m callin that report in vb 6.0.. On my machine(local) its working fine but when I deploy the application on other machine, report generates error for DATABASE NOT FOUND.

I just want to know, How to you create report in such a way that it should determine the .mdb file path regardless of the machine either local or some other.

Its bit urgent so I will be very glad to see any QUICK reponse

Thanks in advance,
Regards,
Faisal

[Malim]

How did you set your database path?

[itpro_79]

I have used Active Data (ADO) and then specified a connectiong string. I did it because i want to use my query in the report.

[Hack]

Welcome to the forums.

I think the path on to you database on the user machine needs to be the same as the path on your machine. Try that and see what happens.

[Malim]

Hack is right. Are you deploying your application over a network? On your machine was the database local to your machine. If it is local to your machine, you can copy the database to the target machine. Or, you can deploy it over your network and redirect your database connection to target the database on your network.