can i access a SQLSERVER database file using DAO conectivity?

Question

I was working in access database,now I like to change into sql server,I have used conectivity DAO, not even used ODBC , is it possible To change this access database to SQL SERVER with same DAO command, or I need this DAO sql commands to ADO connectivity commands, give sugession

Answer 1

Try this link:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/accessmigration.mspx

regards