how to connect from Ms.Access to Sql server ?

[xingselex]

how to connect Access2007 to sql server ? i want to use Access as inter face. whenever i edit record in table in Access, it will affect to sql server directly. because in Access we can see nested table if that tables have relationship. so how to do with this ?

[Lost User]

This[^] article describes the steps both for importing and for linking SQL Server data into Access 2007.

I are troll :)