• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Using Crystal Reports 4.6 OCX

How do you use a Crystal Reports OCX with a security restricted Jet 3.5 DB ?
0
rcfulcher
Asked:
rcfulcher
  • 3
  • 3
1 Solution
 
chewhoungCommented:
Pass in user and password like this:

        cryReport.ReportFileName = "C:\report.rpt"
        cryReport.UserName = "User"
        cryReport.Password = "Password"

0
 
rcfulcherAuthor Commented:

In theory the suggested solution should work - but it didn't for me!

I receive an error code 20000 - no error !  but the report does not appear.  Any ideas?


 
0
 
chewhoungCommented:
Did you change "User" and "Password" to your user id and password?

Can you use the same id and password to login to Access?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
rcfulcherAuthor Commented:

Yes - I used a user name and password which worked when accessing the Access 97 database directly.  The user name was included in a user group with read, update, insert & delete privileges.  Thats why I've been tearing my hair out!


0
 
chewhoungCommented:
Do you mind to mail to chewhoung@yahoo.com for me to check out?
0
 
rcfulcherAuthor Commented:

I'll have another go at trying to resolve the problem myself & then send as much info as possible to you.  Thanks for your help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now