Can I use DAO in .ADP to SQL Server ?

[S.L.]

I've no experience writing code by using ADO before. I usualy uses DAO to
access .MDB database. I deciding to use Access 2002 Project and SQL Server
2000.

I'ld like to ask you. What happen if In .ADP code, I not reference to ADO
object library but references to DAO object library instead ? Can I still
access data in SQL Server ? Or I should not do that, Why ?

TIA

 

[Van T. Dinh]

Sorry, no since DBEngine does not exist in ADP.

See Microsoft Knowledge Base:

http://support.microsoft.com/?id=202192