Connecting MS access to SQL server using DAO

[Shaleen Chugh]

Hi,

I am trying connecting MS access forms to SQL server using DAO.Any idea
about how to code to connect to SQL server using DAO?

Thanks,

Shaleen

 

[Guest]

Actually if your connecting using DAO you dont HAVE to do
it programatically. You can link the tables via the ODBC
manager and your ready to go. It is ADO that you have to
code the connections to the server.