469,575 Members | 1,523 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Crystal Reports .NET 2003 with Access database password

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.

Dec 17 '05 #1
2 1663
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.

Dec 18 '05 #2
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.

Dec 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephan | last post: by
1 post views Thread by Mithun Verma | last post: by
4 posts views Thread by Grant Stanley | last post: by
7 posts views Thread by p | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.