error in crystal report

i m using crystal report 7 in my vb project. i m using visual basic 6. i m getting problem in connecting crystal reports with the access database which is password protected. i m using ado to fetch records. it is working fine with visual basic. the problem is with the crystal report


please help me out. its some kind of urgent

Welcome to the forums. :wave:

We need more information than that.

Quote:

---

Originally Posted by smartpaul

i m using crystal report 7 in my vb project. i m using visual basic 6. i m getting problem in connecting crystal reports with the access database which is password protected.

---

What kind of problems? What error messages are you getting?

Quote:

---

Originally Posted by smartpaul

i m using ado to fetch records. it is working fine with visual basic. the problem is with the crystal report

---

Are these a different set of problems or are they related to the first set?

Are you using the Crystal OCX? If so, you need to prefix the password with a linefeed character, eg

VB Code:

MyReport.Password = Chr$(10) & MyPassword

This is also true if you're using the Crystal APIs.