<div>
The avove code didn't allow me to view. But I took out the &quot;On Error Resume Next&quot; and received the message &quot;Run-Time error '429' ActiveX component can't create object&quot;. I will research this error. 
</div>


The avove code didn't allow me to view. But I took out the "On Error Resume Next" and received the message "Run-Time error '429' ActiveX component can't create object". I will research this error.

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
With AccessApp<br />
&nbsp; &nbsp; .OpenCurrentDatabase &quot;\\server\Shared\SomeFolde<wbr />r\MyDb.mdb<wbr />&quot;<br />
&nbsp; &nbsp; .RunCommand acCmdWindowHide<br />
&nbsp; &nbsp; .RunCommand acCmdAppMaximize<br />
&nbsp; &nbsp; .DoCmd.OpenReport cmbReports.Text, acViewPreview<br />
&nbsp; &nbsp; .DoCmd.Maximize<br />
&nbsp; &nbsp;End With<br />
&nbsp; &nbsp;On Error Resume Next<br />
Set AccessApp = New Access.Application<br />
<br />
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?
</div>
</div>


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:

With AccessApp
    .OpenCurrentDatabase "\\server\Shared\SomeFolder\MyDb.mdb"
    .RunCommand acCmdWindowHide
    .RunCommand acCmdAppMaximize
    .DoCmd.OpenReport cmbReports.Text, acViewPreview
    .DoCmd.Maximize
   End With
   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?

Can't Open Access Reports

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.