Hi All,
Can any one tell me what is the code for calling password protected msaccess from crystal report in VB6.

currently I am trying with the following code but it shows error
"Could not find installable ISAM"

My code is:
Private Sub Form_Load()
   Dim crystal As CRAXDRT.Application
   Dim report As CRAXDRT.report
   Dim crxTable As CRAXDRT.DatabaseTable

   Set crystal = New CRAXDRT.Application

   Set report = crystal.OpenReport(App.Path "\data\TESTPWD.rpt")
   CRViewer.ReportSource = report
   For Each crxTable In report.Database.Tables
            crxTable.SetSessionInfo "", Chr(10) & Password
   Next crxTable
  CRViewer.ViewReport

End Sub

are you sure that the databases inside the report has the correct path???

maybe the path is virtual from wherever you are running it and it cannot found it...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Thanks for your response,
Yes Unfortunately path is correct.

then I don't have a clue.. sorry... someone else???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Reinstall the access +mdac +jet4.0 no exist xbs110.dll and use ADO not use DAO

Sorry I not speak in english