The report is connected to a MS ACCESS .MDB with a .MDW system database file.
Since I want to dynamically change the database path programmatically, I'm having a hard time figuring out the correct ConnectionInfo settings in viewing the report.
I tried searching on the net but failed to come up with the correct solution.
Below is a sample of my ConnectionInfo code. Appreciate any help or suggestion.
Expand|Select|Wrap|Line Numbers
- With crConnectionInfo
- .ServerName = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\Documents\db.mdb;Jet OLEDB:System Database=D:\Documents\CRBSecurity.mdw;User ID=MyUsername;Password=Mypassword;"
- .DatabaseName = "D:\Documents\db.mdb"
- .UserID = "MyUsername"
- .Password = "Mypassword"
- End With