Crystal Reports 4.5 ... Help Access Security
Quote:
> 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.
Ran into the same problem. If you talk to Seagate (Crystal) they will
tell you, as you have confirmed, that CR 4.x does not use Access x.x
data via DAO if the database is secure. The only work around is to
connect to the data base via an ODBC driver for Access.
Programmatically place the User ID and Password in the ODBC Connect
string.
FYI Seagate swears that CR 5.0 does DAO connects to secure Access
databases. I purchased the upgrade and if it does it's not straight
forward, ie. received a lot of errors when connecting.
Your fun has just begun.
