I am trying to construct a report from an Access 2.0 database which has security
features applied to it.
When I attempt to create a new report in Crystal 4.5 prof the message :

        No permission for "tableName"

appears for each table in the database.

There seems no solution to this problem (ie no way of logging into the database
with the USER ID and Password) before constructing the report.

Can anyone out there help me with this problem ?

Thanks in anticipation

--
Geoff Parkin

: I am trying to construct a report from an Access 2.0 database which has security features applied to it.
: When I attempt to create a new report in Crystal 4.5 prof the message :

:         No permission for "tableName"

: appears for each table in the database.

: There seems no solution to this problem (ie no way of logging into the
database with the USER ID and Password) before constructing the report.

: Can anyone out there help me with this problem ?

    In Crystal's INI file ,look for a reference to the SystemDB.  Usually
when you log into a Access DB w/o a username password,  you are going in as
the Admin user (an account that has been stripped of it's privledges during
the securing of the DB).  It sounds like the database's MDA file is different
from the Access default SystemDB (found in msacc20.ini).  If you try to hook
up to an access DB with that, Admin will be assumed and you will have limited
rights. If the systemDB is set to the proper file, it should work

: Thanks in anticipation

: --
: Geoff Parkin