Linked tables

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

Hi,

Can anyone tell me how to create a linked table in an
Access database, using ADO.NET?

Thanks
Iain
 
There's no way to do this directly from ADO.NET. You'd need to use COM
interop, using either the DAO or ADOX APIs.

--Mary
 
That is not really what ADO.NET does. ADO.NET queries and abstracts data for
you, and since it allows you to run commands on the d/b you can even specify
DDL in it ,.. but you shouldn't for better design sake. SQLDMO is the right
tool for that.

Creating linked tables - the right tool for that would be Access VBA, and
that is .NET accessible.

- Sahil Malik
Independent Consultant
You can reach me thru my blog - http://dotnetjunkies.com/WebLog/sahilmalik/
 
Thanks for the reply.

If i were to do it using DDL, do you know what the syntax
would be to create a linked table?

Thanks
Iain
 
Ah, i've been trying to do it without using anything
else. It's actaully some DAO code that i'm updating.

Thanks
Iain
 
Unfortunately, Access SQL DDL is very limited in this regard. You can
create a regular Jet table using DDL, but not a linked table.

--Mary
 
Back
Top