How to Retrieve records from MSACESS dbase with password

[antonio26]

Hello guys,

Im trying to retrieve some records from MS ACCESS dbase with password in my VB Codes but I keep on getting this error "Open database session failed", If I try to unset the password of that dbase, it does work... however, I really need to set the password for security reason. I have this typical code of the CRViewer though.

---------------------------------------
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
---------------------------------------

 

[kab555]

Here is a section of code that you can use. I usually insert between the two CRViewer... code lines

CRViewer1.ReportSource = Report

Report.Database.Tables.Item(1).SetLogOnInfo "servername_here", "databasename_here", "login", "password"

CRViewer1.ViewReport

The inserted code should be all on one line