Skip to Content
0
Former Member
Jul 07, 2009 at 05:43 PM

Crystal reports server and microsoft access db

156 Views

Hi

I have created a Crystal Report using Crystal Reports XI. In terms of a datasource I simply used a unc path to the actual mdb file.

I can open the report local on the PC in CR XI and the report runs no problem however I have deployed to our Crystal Reports server XI so that users can use it.

The problem is that when I try to run the report from the Info view console it keeps asking me for a user id and password. I have logged into the CMC admin console and looked at the properites of the report and the process/database tab however not matter what I configure in there it either asks for the username and password or says invlaid object when I try to view the report.

I have created other reports which have used an SQL database as the data source and published them to the CR Server and they work no problem so I am guessing I need to change something for using an Access DB as the dataource. Not usr eif that change is in Crystal Reports XI or Crystal Reports Server?

Can anyone help?

Many thanks