Crystal Report 8.5 and MS ACCESS database password

[theamis]

Hi!

I am in the middle of debugging a visual basic program where the Database it's using is an MS ACCESS with a password. It has no problem with the add,edit,delete and other basic functions except with the printing of record where whenever it is click it generate an error. I tried taking off the password in the database since it might be the cause of the problem which prove to be right. The crystal report function perfectly. However, when I put back the password, the error comes again.

I really hit a dead end here and I will appreciate it very much if anyone can give me some help in dealing with crystal report and database with password.

Thank you very much

 

[kenhamady]

You have to log into the database before you launch the report.
Which integration method are you using? See faq149-237.
Are you connecting to the database via ODBC?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[theamis]

Hi Ken!

Thanks for respond in my inquiry. The integration method I'm using is by OCX (crystal32.ocx) and my report connects to the data by ODBC.

I'll appreciate very much for your help about this problem of mine. Thank you very much.

 

[kenhamady]

Is your app logging the report into the data?
You can use the Connect property as one options.

I am pretty sure you can use one of these as an alternative
LogOnServer
SetLogonInfo

I forget which one is available in the OCX. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com