i have a access database password protected......and on front end i am using vb.net 2003,
now problem is that i have created a crystal report which will print some info...i am calling that report from a crystal report viewer in vb.net...but when i run the application that report requires password and database location.....
how can i provide these information through coding in vb...so that it wont require them by user...i have visited the crystal report site but there are only tutorials located about sql or other not about access????

well! guys after some great search...
i found many ways to do this..but all of them was not working with database level access security....
but the best option is to use Ado.net.....create a report with that thats a best option.

You can use following solutions.
1)Click on
Database
Database Expert
Create New Connection
File System Data
Create New file with required fields to print report

Or to set this thing at the time of adding new report.

Now Add this fields later to the your report

2) Create Object of report and provide parameters if ur r using.
rpt.ParameterFields(1).AddCurrentValue (55)
3) Set Database source with recordset Nomatter what database u r using oracle, mssql or ms-access
rpt.DATABASE.SetDataSource rs
4)Export, print or view report
rptCheque.Export True

Hope u will find this enough.

-Saurin