hihi~~~ everyone....

(i use OLEDB connect)
vb connect the access is no problem, but use this code cannot connect the crystal report
still need me entry the  login id , password, it poup up the  databse login...
because Access only set password , no UserID


 Dim myTables As Tables = crReport.Database.Tables
        For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables

            Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo
            '            For Each Table In reportdoc.Database.Tables
            myTableLogonInfo = myTable.LogOnInfo
            myTableLogonInfo.ConnectionInfo.ServerName = "C:\aaa.mdb"
            myTableLogonInfo.ConnectionInfo.DatabaseName = "Hello"
            myTableLogonInfo.ConnectionInfo.Password = "123456"
            myTable.ApplyLogOnInfo(myTableLogonInfo)
        Next myTable