Connect to sql server from ms access 2010 through DAO

[abhijeetkadam]

Hi all,
Thanks for viewing this question.
I have a code which connects to sql server using DAO. I would like to know is that do my system require sql server native client installed to run this code? or what software needs to be installed to have this code works for me?
Thanks
Abhijeet

[ItsMe]

I am not an expert on the subject but I believe all you need are the drivers installed on the client machine. As long as you have the DNS name and select the correct type of connection, you should be OK to create an ODBC connection. Then you can open a recordset using VBA. Another option would be to create a project file and connect to SQL server using the .adp file extension. This uses a different database engine and has its own set of rules.

Hopes this helps