Open a FORM in MS Access Application from DotNet Code

[Wisdom]

Scenario is: We have a Application developed in MS Access 2003 + VBA. Now for
new features, we are relying on VB.NET. We often have to link up/integrate
our both applications. For example open Dot Net Application from Access or
open Access forms from Dot Net Application. But i am unable to refrence and
open access form from Dot Net Based application.

 

[Albert D. Kallal]

in vb you can go:

Dim accessApp As Object

Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDatabase ("C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb")
accessApp.Visible = True
accessApp.DoCmd.OpenForm "unboundcheckbox"


So, you have to use object automaton to accomplish your goal, and simply
declare an instance of ms-access to run.. Note you can NOT do the above with
the runtime edition of access since it don't allow a copy to be launched
*unless* you supply a file name as part of the command line........