Accessing another application during run-time

I have developed an application with a VB front-end and Access 2000 back-end. I would like to access reports designed in Access 2000, via the visual basic run-time form, in much the same way that crystal reports can be accessed.

Your advice please,

cheers,

Aussie

[sanon]

This API function may solve your need.

Public Declare Function WinExec Lib "kernel32" Alias "WinExec" (ByVal lpCmdLine As String, ByVal nCmdShow As Long) As Long

'nCmdShow = 1: Show the application when it's running
'nCmdShow = 0: Hide an application like running in background

[Shafee]

Or you can use

Dim Acc As Access.Application

You must have Microsoft Access 9.0 Object Library added to your project references.

Sanon, I have seen a lot of you guys using API over this method. What is the advantage of using API for this? (I would like to improve my knowledge)