Hello,
I'm attempting to print a Crystal 8.5 report from VB where the underlying
Access Database has a database password. The report currently connects to
the Access database via ODBC - File DSN.
I'm using the Crystal Reports 8.5 ActiveX Designer Runtime Library along
with the following code:
Dim Oapp As New CRAXDRT.Application
Dim Report As CRAXDRT.Report
Set Report = Oapp.OpenReport("Q:\report.rpt")
Report.Database.LogOnServer "P2SODBC.DLL", "q:\dsnname.dsn",
"q:\database.mdb", "Admin", "password"
Report.DiscardSavedData
Report.PrintOut
Before the database was password protected, the report ran fine from VB.
I'm not certain that the syntax I'm using is correct.
Thanks in advance,
Dave
This document should only be read by those persons to whom it is
addressed and is not intended to be relied upon by any person without
subsequent written confirmation of its contents. Accordingly, PRECISION
MACHINE AND MANUFACTURING COMPANY disclaims all responsibility and accepts
no liability, including in negligence, for the consequences for any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation.
If you have received this E-mail / Fax message in error, please
notify PRECISION MACHINE AND MANUFACTURING COMPANY immediately by
telephone. Please also destroy and delete the message.
Contact:
By Phone: Systems Administrator at (515)-733-5181
By Email: sysadmin@...
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this E-mail / Fax message
is strictly prohibited.
I'm attempting to print a Crystal 8.5 report from VB where the underlying
Access Database has a database password. The report currently connects to
the Access database via ODBC - File DSN.
I'm using the Crystal Reports 8.5 ActiveX Designer Runtime Library along
with the following code:
Dim Oapp As New CRAXDRT.Application
Dim Report As CRAXDRT.Report
Set Report = Oapp.OpenReport("Q:\report.rpt")
Report.Database.LogOnServer "P2SODBC.DLL", "q:\dsnname.dsn",
"q:\database.mdb", "Admin", "password"
Report.DiscardSavedData
Report.PrintOut
Before the database was password protected, the report ran fine from VB.
I'm not certain that the syntax I'm using is correct.
Thanks in advance,
Dave
This document should only be read by those persons to whom it is
addressed and is not intended to be relied upon by any person without
subsequent written confirmation of its contents. Accordingly, PRECISION
MACHINE AND MANUFACTURING COMPANY disclaims all responsibility and accepts
no liability, including in negligence, for the consequences for any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation.
If you have received this E-mail / Fax message in error, please
notify PRECISION MACHINE AND MANUFACTURING COMPANY immediately by
telephone. Please also destroy and delete the message.
Contact:
By Phone: Systems Administrator at (515)-733-5181
By Email: sysadmin@...
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this E-mail / Fax message
is strictly prohibited.