Hello,

I am using VB6 and Access2000.I want to create a report using crytal report9.My database has password protected.I can create reports with no password protected databse, but with passwords.
Pls explain me how to create reports with password protected database(I use ODBC Datasource).

What error are you getting?

Hi Mahanama,

When i read your question i started thinking how to acomplish this.
But there is a very simple way..

You can set your database password at the time of creating DSN.
Click on "Advanced" button to set your Username and password.
User name must be "Admin".

Regards,
Rajnikant