CRYSTAL REPORT NOT OPENING ACCESS MDB (Password Protected MDB)

[absarkhan]

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.

[diban]

Your trouble started dued to the fact that you changed the db properties after creating objects that refer to this object. Try the following (provided you now have a valid and working datasource and connection)

1. Create a new Crystal Report and reset all the properties.

2 If that doesn't work try recreating a fresh connection with a new data source and repeat step 1.

Hope this helps