I guess I misstated, I had created a new report and had not saved the data. I want it to show fresh data every time they view it. I'm using SQL server for the data.

I found the answer though:


.oReport.Database.Tables(1).SetLogOnInfo("CQI-TERMSERV", "ctore", "ctore", "cqi$$")

Craig thanks alot, your article on your website is great.

Kirk