MS Access和VB.NET之间的通信 [英] Communication between MS Access and VB.NET
问题描述
您好！
我有MS Access应用程序和VB.NET应用程序。
现在我想要在这两个
应用程序之间实时交换信息。
例如，VB.NET应用程序想要知道活动表格的名称
Access应用程序中的
。或者Access应用程序想要知道VB.NET应用程序的文本框中的
日期。等等...
这两个应用程序只能在计算机上运行一次。
问题是：
- VB.NET如何访问Access应用程序？
- Access如何访问VB.NET应用程序？
- 一旦VB.NET应用程序访问Access应用程序，它可以在Access应用程序中运行
函数。这也可能是相反的吗？
原则上，这两个人应该能够说话。相互之间。
我知道这两个应用程序都可以使用DDE - 但必须有更多的
最新选项。
有什么想法，我怎么安排这个？
非常感谢您的帮助！
来自奥地利的问候
Gerald
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
推荐答案
你最好的办法就是抓住Visual Studio Tools For Office，这就是
最灵活的方式使用VS2003或上面的
与Office应用程序进行交互。
-
OHM（特里烧伤）*使用以下内容给我发电子邮件*
Dim ch（）As Char =" ufssz / cvsotAhsfbuTpmvujpotXjui / OFU" .ToCharArray（）
For我作为Int32 = 0到ch.Length - 1
ch（i）= Convert.ToChar（Convert.ToInt16（ch（i）） - 1）
下一步
Process.Start（" mailto："& New String（ch））
-
" Gerald Bader" < GE **** @ gmx.at>在消息中写道
新闻：O2 ************** @ TK2MSFTNGP14.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/cvsotAhsfbuTpmvujpotXjui/OFU".ToCharArray()
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.at> wrote in message
news:O2**************@TK2MSFTNGP14.phx.gbl...
你好！
我有一个MS Access应用程序和一个VB.NET应用程序。
现在我想在这两个
应用程序之间实时交换信息。例如，VB.NET应用程序想要知道Access应用程序中活动
表单的名称。或者Access应用程序想要知道VB.NET应用程序的文本框中的日期。等等...
两个应用程序只能在计算机上运行一次。
问题是：
- VB.NET如何访问Access应用程序？
- Access如何访问VB.NET应用程序？
- 一旦VB.NET应用程序访问Access应用程序，它就可以在Access应用程序中运行
功能。这也可能是相反的吗？
原则上，两人应该能够说话。我知道两个应用程序都可以使用DDE - 但必须有更多的
最新选项。
任何想法，如何我可以安排这个吗？
非常感谢您的帮助！
来自奥地利的问候
Gerald
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
嗨！
Thanx快速回复！
问题是，现有的使用MS创建访问应用程序
Access 2000.因此没有可用的.NET功能。
此外我使用VS.NET 2002.
我必须遵守这些版本。
我的案例中有哪些DDE替代品？
问候
Gerald
Hi!
Thanx for your fast reply!
The problem is, that the existing Access application is created with MS
Access 2000. So there are no .NET capabilities available.
Moreover I use the VS.NET 2002.
And I''m bound to these Versions.
What alternatives to DDE do exists in my case?
Greetings
Gerald
您仍然可以使用COM Interop，只需在
中添加对Access DDL的引用即可访问参考部分ACCESS对象层次结构。
-
OHM（Terry Burns）*使用以下给我发电子邮件*
Dim ch（）As Char =" ufssz / cvsotAhsfbuTpmvujpotXjui / OFU" .ToCharArray（）
For i As Int32 = 0 To ch.Length - 1
ch（i）= Convert.ToChar（Convert.ToInt16（ch（i）） - 1）
下一页
Process.Start（" mailto：" &安培;新字符串（ch））
-
" Gerald Bader" < GE **** @ gmx.at>在消息中写道
news：en ************** @ TK2MSFTNGP12.phx.gbl ...
You can still use COM Interop, simply add a reference to the Access DDL in
your references section to access the ACCESS object hierarchy.
--
OHM ( Terry Burns ) * Use the following to email me *
Dim ch() As Char = "ufssz/cvsotAhsfbuTpmvujpotXjui/OFU".ToCharArray()
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.at> wrote in message
news:en**************@TK2MSFTNGP12.phx.gbl...
嗨！
Thanx为您的快速回复！
问题是，现有的Access应用程序是使用MS
Access 2000创建的。因此没有可用的.NET功能。此外，我使用的是VS.NET 2002.
我必须使用这些版本。
在我的情况下，DDE有哪些替代方案？
问候
Gerald
Hi!
Thanx for your fast reply!
The problem is, that the existing Access application is created with MS
Access 2000. So there are no .NET capabilities available.
Moreover I use the VS.NET 2002.
And I''m bound to these Versions.
What alternatives to DDE do exists in my case?
Greetings
Gerald
这篇关于MS Access和VB.NET之间的通信的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
