We are nearing completion of a project which uses an mdb database. The
database is to be encrypted. Can Crystal create reports from an encrypted
mdb file either using embedded code, OCX etc. or the standalone Crystal
product? We will be using 6.0.

Bob,

No personal experience with this, but...how are you encrypting the data?
Your own (front-end) algorithm, or using some facility in Access? How do
you get unencrypted data out to an application?

Since you're using CR6, one way you could go is to read data out into a
calling application, unencrypt, and use the "Crystal Data Object" to pass
the data to CR for reporting. Alternatively, you could decrypt to a
temporary
table and report directly from there.

If I were doing this on SQL Server, I would do the encryption via an
insert/update
trigger and decrypt when reading data by using a stored procedure to do all
the
selects...
--
Les Schmalzbach
(remove nospam- to reply).