If Access Database is password protected then how to access it in crystal report in VB?

If Access Database is password protected then how to access it in crystal report in VB?
sanjusambheAsked:
Who is Participating?
 
PWinterCommented:
Hi.

In VB you should loop through tables in your report and for each table provide the password at the property of "ConnectionProperty".
There are examples at Crystal Report's Developers Help (CrystalDevHelp.chm) under chapter of "How toconnect to a secured Microsoft Access database".

Good Luck.
PW
0
 
heskyttbergCommented:
Hi!

You should really consult a book or manual to Crystal Report on this.

Regards
/Hasse
0
 
walterecookCommented:

Here's an example of a password connection using ADO

Set gConn = New ADODB.Connection
gConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & db & ";Jet OLEDB:Database Password=some;"

and one in DAO
Set db = Workspaces(0).OpenDatabase(App.Path & "\someDb.mdb", False, False, ";pwd=somePass")

Hope that helps
Walt
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.