access and crystal 9

[Krzysztof via AccessMonster.com]

Good Day!

i am trying to do what seems like the impossible. i have a crystal report
that is linked to our main accounting software, and this is SQL database. i
have created access database using ODBC, so some of the data is from SQL,
some entered and stored in access db. ok fine, now i need to add to crystal
report, the fields from access db. that went ok. Now, if i run the report
from crystal, it works fine, it prompts me for input criteria, and then for
access db password (i had to set up users/passwords on access db), just like
it should. now i create a link from accounting software to CR, and it does
not run. i have been working with the 'Crystal Report Viewer Control 9' and
having no luck. is there a way i can view this CR from access. i would be
very glad to explain this further if needed. TIA~

~K

 

[Krzysztof via AccessMonster.com]

i have succeeded with integration, and one report works fine, but another
report will not let me run it. it says login failed. cannot retrieve error
message from server. i am pretty sure of the problem, one of the data
sources of report is a secured access databse, and CR prompts for login
password. any one know how to store password, maybe? please help much TIA

~K

 

[Tom and Dianne Meyer]

From: "Krzysztof via AccessMonster.com" <u11875@uwe>
Newsgroups: microsoft.public.access
Date: Thu, 10 Nov 2005 19:35:27 GMT
Subject: Re: access and crystal 9

i have succeeded with integration, and one report works fine, but another
report will not let me run it. it says login failed. cannot retrieve error
message from server. i am pretty sure of the problem, one of the data
sources of report is a secured access databse, and CR prompts for login
password. any one know how to store password, maybe? please help much TIA

~K