Printing Microsoft Access 2003 report in VB 6

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
Who is Participating?
Raynard7Connect With a Mentor Commented:
If they do not have access installed then you will not be able to open the report on the machines.

You would be best using ADO to connect to the db and then recreate the report in your application.

The security questions relate to the security settings on the individual  machine.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.