pasword manager

[elixir_5000]

i have create da new vb.net , ms access and cr 8.0 project . the database is password protected so every time crystal report in opend it demands for the database pass word is there some way to avoid that or can the password be pre provided by some manner ???

[VBDT]

yes you can include the password in the connection string. Check this link for MS Access connection strings.

[elixir_5000]

but i am not giving crystal report any connection string so where to add the string for crytal report to connect with data base

[lingsn]

If you use the crystal report that will connect to the database directly and wish the cystal report to login itself, may be you can look at this link

http://technicalsupport.businessobje...1%200%20356275

[elixir_5000]

If you are using an Oracle database, specify the schema name for 'myOwner' but do not specify a value for 'DatabaseName'
:crTable.Location = myDBName & "." & myOwner & "." & crTable.Location.Substring

can u plz tell me what to write in my owner and my db name

[lingsn]

If you are reporting off an Access database, then
specify either the 'ServerName' or 'DatabaseName'
to the 'ConnectionInfo' Object depending on
how you are connecting to Access.

For example, if you are connecting to Access
through ODBC, then set the 'DatabaseName' for the
'ConnectionInfo' object as follows:

With crConnectionInfo
.DatabaseName = "C:\mydatabase\mydata.mdb"
End With

If you are connecting to Access through OLE DB,
then set set the 'ServerName':

With crConnectionInfo
.ServerName = "C:\mydatabase\mydata.mdb"
End With


It is not possible to report of a secured Access
database using a native connection. See knowledge
base article C2010460 for more information.