Crystal Reports .NET 2003 with Access database password

[daniel]

Hi all,

I'm using Crystal Reports for Visual Studio .NET 2003 against a fixed
Access database with a fixed database-level password, using OLEDB. I
designed the reports just fine, but I'm not finding a way to actually
use them from code.

Is there really no way to either embed the fixed connection info in the
report or somehow get the string "Jet OLEDB:Database Password=password"
into the OLEDB connection string from code? If not, my only options
are to move to a full version of Crystal, or translate all my reports
to the push model.

[Larry Linson]

The microsoft.public.access.reports newsgroup deals specifically with
Access' Reporting features. You are far more likely to get the answer you
need from one of the other newsgroups to which you crossposted -- devoted to
Crystal Reports, or one devoted to whichever DotNet language you are using.

Larry Linson
Microsoft Access MVP
<da****@software-labs.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi all,

I'm using Crystal Reports for Visual Studio .NET 2003 against a fixed
Access database with a fixed database-level password, using OLEDB. I
designed the reports just fine, but I'm not finding a way to actually
use them from code.

Is there really no way to either embed the fixed connection info in the
report or somehow get the string "Jet OLEDB:Database Password=password"
into the OLEDB connection string from code? If not, my only options
are to move to a full version of Crystal, or translate all my reports
to the push model.

[andy]

You don't need to hand the report a connection, password or anything it
keeps whatever you set it up with.
So if you enter the connection in when you set the report up then it
should have that.

Right click on a bit of your report has nothing in it.
You should get a pop up menu includes the option Database.
Choose set database location from this.
You should find this fairly self explanatory but....

Set up a new connection and include the password in the stuff it asks
you for.
Substitute this for the old source.