I have created an Database system in VB-6 using ADODB connection (Provider=Microsoft.Jet.OLEDB.4.0) for ACCESS Database (mdb) & for reports i used Crystal Report 8.5.

This project was running superb but recently i protect my ACCESS Database (mdb file) with password to open. (PASSWORD PROTECTED). Then i also defined/Add this Password in my VB MODULE's sub main's CONNECTION STRING.

Now the project is running superb.
But the Problem is that :
I CAN'T OPEN ANY REPORT IN MY PROJECT, VB Project gives me error. I know that this is a problem for CRYSTAL REPORT which is unable to opening a password protected file.

PLEASE CAN ANY ONE GIVE ME SOLUTION TO HOW & WHERE I DEFINE THE PASSWORD TO OPEN MY PASSWORD PROTECTED (MDB FILE) WITH CRYSTAL REPORT FOR MY VB-6 PROJECT.