MS Access - Programmatically Link a Table

[Dmitry Akselrod]

Hello everyone,

Can someone please point me to an example of how you could programmatically
link a table from one MS Access database into another? I am working in
VB.NET, but C++ / C# will do as well.

Thanks!
dmitry

 

[Albert D. Kallal]

You need at the very least the dao object model here.

Here is an example in VBA:

http://www.mvps.org/access/tables/tbl0009.htm

 

[Cor Ligthert[MVP]]

Dmitry,

Depends what you want, you can always create a dataset that has more tables
which come from all kind of databases.

Cor

 

[Dmitry Akselrod]

Cor, thanks. I actually need to immitate the access function of linking a
table into a database. I am not so concerned about linking multiple tables
in a dataset. I just need to immitate access functionality
programmatically.

 

[Dmitry Akselrod]

Albert, thanks. Am I correct to assume that if I reference the MS Access
Object Model in my VB.NET code, I should be able to do something similar to
this VBA example?

dmitry

 

[Armin Zingler]

Albert, thanks. Am I correct to assume that if I reference the MS
Access Object Model in my VB.NET code, I should be able to do
something similar to this VBA example?

You don't need to reference MS Access to do the same. Albert meant you can
reference DAO to do the same.


Armin

 

[John W. Vinson]

Hello everyone,

Can someone please point me to an example of how you could programmatically
link a table from one MS Access database into another? I am working in
VB.NET, but C++ / C# will do as well.

Thanks!
dmitry

Take a look at the TransferDatabase method. It gives you the choice of
importing or linking. It's a VBA method, so I don't know if it's available in
the other languages.