Crystal Report and password protected Access database

[Jape]

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/[email protected]&rnum=1

Jape

 

[Elton Wang]

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
(e-mail address removed)