• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • 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
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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