Password Prompt when opening crystal report.Net connected to MSAccess database.

Hello reader.
Well this faq is related to a problem very frequently faced by many new Crystal Report Developers (I faced it too). But I was quiet sure of the fact that this problem has some solution bcoz problem without a solution isn't a problem.
Sometimes when we develop a report using MSAcess database we are prompted for password while viewing the report even if it hasn't got one and we go nuts trying several round abouts for this problem.

Solution:
When you start developing a new report and go to Add/Remove Database
1. DO NOT SELECT "OLE DB (ADO)" as your datasource.
2. Click "More Data Sources" then double click "Access/Excel (DAO)".
3. In "Database Name" give complete path to the database or click button next to it to browse for it.
4. In "Database Type" select "Access".
5. If your database is NOT PROTECTED by PASSWORD click "Finish".
6. Whereas if your database is PROTECTED by PASSWORD click "Secure Logon" checkbox.
7. Write your password in "Database Password" textbox.
8. Leave the other fields empty.
9. Click "Finish".

If you have a report already developed and facing this problem:

1. Right click "Database Fields" in "Field Explorer".
2. Click on "Set Location"
3. Your current database wil be selected by default.
4. In "Replace with" section repeat the above mentioned steps to access your database.
5. Select the database which you just added.
6. Click "Replace" button to replace the existing database with new one.
7. Click "Close" when database is replaced.
PS: This process wont effect the fields or designing of your report. It will just replace th database.

It worked for me and I am sure it will work for you too.