Problem in Crystal 8.5 with Access Database

Printable View

Apr 11th, 2005, 05:38 AM
itpro_79

Problem in Crystal 8.5 with Access Database

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
Apr 12th, 2005, 09:36 AM
Malim

Re: Problem in Crystal 8.5 with Access Database

How did you set your database path?
Apr 14th, 2005, 05:29 AM
itpro_79

Re: Problem in Crystal 8.5 with Access Database

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.
Apr 14th, 2005, 07:01 AM
Hack

Re: Problem in Crystal 8.5 with Access Database

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.
Apr 14th, 2005, 07:22 AM
Malim

Re: Problem in Crystal 8.5 with Access Database

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.