Communication between MS Access and VB.NET

[Gerald Bader]

Hello!

I've got an MS Access Application and a VB.NET Application.

Now I want to to exchange information in real time between these two
applications.

For example the VB.NET application wants to know the name of the active Form
within the Access application. Or the Access application wants to know the
date within a textbox of the VB.NET application. And so on...

Both applications can run only once on a computer.

The problems are:
- How can VB.NET access the Access application?
- How can Access access the VB.NET application?
- Once the VB.NET application accessed the Access application, it can run
functions within the Access application. Is this possible reversely, too?

In priciple the two should be able to "talk" with each other.

I know that both applications could use DDE - but there must be a more
up-to-date option.

Any idea, how I can arrange this?
Many thanks already in advance for your help!
Greetings from Austria

Gerald

[One Handed Man \( OHM - Terry Burns \)]

I dont think thats strictly true, the templates are pre-defined for Word and
Excell but the ability to communicate with access is there as is with
powerpoint.

--
OHM ( Terry Burns ) * Use the following to email me *

Dim ch() As Char = "ufssz/cvsotAhsfbuTpmv ujpotXjui/OFU".ToCharArra y()
For i As Int32 = 0 To ch.Length - 1
ch(i) = Convert.ToChar( Convert.ToInt16 (ch(i)) - 1)
Next
Process.Start(" mailto:" & New String(ch))
--
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

Visual Studio tools for office only helps with word and excel.

Ken
-----------------
"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in
message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Your best bet is to get hold of Visual Studio Tools For Office, this is
the
most flexible way to interact with Office applications using VS2003 or
above.

--
OHM ( Terry Burns ) * Use the following to email me *

Dim ch() As Char = "ufssz/cvsotAhsfbuTpmv ujpotXjui/OFU".ToCharArra y()
For i As Int32 = 0 To ch.Length - 1
ch(i) = Convert.ToChar( Convert.ToInt16 (ch(i)) - 1)
Next
Process.Start(" mailto:" & New String(ch))
--
"Gerald Bader" <ge****@gmx.a t> wrote in message
news:O2******** ******@TK2MSFTN GP14.phx.gbl...

Hello!

I've got an MS Access Application and a VB.NET Application.

Now I want to to exchange information in real time between these two
applications.

For example the VB.NET application wants to know the name of the active
Form
within the Access application. Or the Access application wants to know
the
date within a textbox of the VB.NET application. And so on...

Both applications can run only once on a computer.

The problems are:
- How can VB.NET access the Access application?
- How can Access access the VB.NET application?
- Once the VB.NET application accessed the Access application, it can run
functions within the Access application. Is this possible reversely, too?

In priciple the two should be able to "talk" with each other.

I know that both applications could use DDE - but there must be a more
up-to-date option.

Any idea, how I can arrange this?
Many thanks already in advance for your help!
Greetings from Austria

Gerald