How to connect Cr. Report with Ms Access Database using password secur

[Guest_imported]

Hi
How I can make a connection to Ms Access database if I am using a security password
I am working with dao in crystal report.
Note: I am righting SQL statement.
Error occurs: Error Password.

 

[kenhamady]

Where are you writing the SQL statement?
What version of CR?
Are you going to launch this from an app? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Guest_imported]

Hi
How I can make a connection to Ms Access database if I am using a security password
I am working with dao in crystal report.
Note: I am righting SQL statement.
Error occurs: Error Password.
Where are you writing the SQL statement?
When adding new table there is a choice (SQL table) then click on active data DAO, Browse the database
Finally writing the SQL.
version 6
Are you going to launch this from an app? Yes VB5.

 

[kenhamady]

I am not familiar with this specific error.

Are you using active data so that you can pass a recordset to the report from the app or do you want Crystal to read the data directly? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)