I have developed a VB2005 Express Edition application that (as part of further development) now needs to be able open and give focus to an MS Access 2003 utility that is already programmed, up and running and in use by other users.
Currently, my program will successfully fire the Access program (via the code shown below), but once the Access program has processed the specific AutoExec.DVT macro, Access disappears from the screen and is then no longer part of the current running applications, although a process MSACCESS can be seen within the Task Manager Processes window.
What I would like to do, is have the Access utility fire up, give full focus to Access and then when Access is closed, our users can continue with the VB Program in the normal way. This query is not related to problems of sql, datatables, or queries, but to simply using another utility.
Private Sub StatisticalProcessControl()
Dim conn As Access.Application
conn = New Access.Application
.OpenCurrentDatabase("C:\Documents and Settings\kblakesley\" & _
"My Documents\DATABASES\Under Development\DVTCamera\SPCProgram\" & _