I found the fucntion on Experts Exhange
"Public Function fPrintReportOLE(theDBName As String, theReport As String) As Boolean"
and it works but it opens the Database and the database has a pop up security message.
Number 1 I do not want the user to open the database They will not have access installed only run time
Number 2 How do I get rid of the security questions?
Any help I would be thankfull