Hi,

I have a password protected access database. There's no username /
password, only the database password. When I'm creating the connection
to database the dialogbox ask's username (blanc) password (blanc) and
also the Jet Database password. After this everyting works just fine
in desing-mode, but when I'm trying to debug the program I get this
another dialogbox where I'm being asked username and password but not
the jet database password... So, I'm unable to connect. I've really
starting to get desperate on this one, so PLEASE help me out. If you
didn't understand what I'm saying (probably because of my poor
english) check out this url, it has an explanation about the same
problem.

http://groups.google.fi/groups?q=Crystal+report+login+to+a+database+password+protected+MS+Access+File&hl=fi&lr=&client=firefox-a&selm=e8DVQRtJEHA.2380%40TK2MSFTNGP09.phx.gbl&rnum=1

Jape

Hi Jape,

Actually, you can create a DataTable (or DataTables) with
exact the same scheme as your crystal report query. And
the DataTable contains data the report will show. Then
bind the DataSource of the report with the DataTable. This
way the report doesn't require logon info. (If the report
has some parameters, you also need assign them to the
report.)

Hope it's helpful to you.

Elton Wang
elton_w***@hotmail.com

works just fine
I get this
password but not
I've really
out. If you
q=Crystal+report+login+to+a+database+password+protected+MS+
Access+File&hl=fi&lr=&client=firefox-
a&selm=e8DVQRtJEHA.2380%40TK2MSFTNGP09.phx.gbl&rnum=1
Show quoteHide quote

Microsoft Data Access Block and static methods
Cannot access Columns and Rows of some Strong-Typed Dataset's DataTables
Comparing two DataSets with a Merge
Is this possible
does Ado.Net 2.0 have bulk insert functionality?