Can't Open Access Reports
Posted on 2006-04-03
I have a vb6 application that opens some reports created in Access. The application works fine, except when I package and deploy the application, I can't view the reports from the machine in which it was installed. This is the code that opens the reports:
.DoCmd.OpenReport cmbReports.Text, acViewPreview
On Error Resume Next
Set AccessApp = New Access.Application
I can manually locate the Access database and open the reports on the machine that the application is installed, but the application will not open the reports. Any Help?