MS Access - Programmatically Link a Table

  • Thread starter Thread starter Dmitry Akselrod
  • Start date Start date
D

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
 
Dmitry,

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

Cor
 
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.
 
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
 
Dmitry said:
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?
Click to expand...

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


Armin
 
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
Click to expand...

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.
 
Back
Top