Can I use DAO in .ADP to SQL Server ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S.L. - 18 Sep 2003 07:58 GMT

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 ?

(if not necessary, It good for me to not waste time to study programming
using ADO)

Reply to this Message

BJ Freeman - 18 Sep 2003 13:52 GMT

When an ADP is opened, it usually connect to the SQL Server. This is set up
in the File->connection dialog.

to do something on the SQL server, use
dim RS as ADODB.Recordset

set RS = currentproject.connection.execute( "Select * from XmlTable") for
read-only or

RS.Open "Select * from XmlTable", currentproject.connection, adOpenKeyset,
adLockOptimistic
for r/w

> 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
[quoted text clipped - 6 lines]
> (if not necessary, It good for me to not waste time to study programming
> using ADO)

Reply to this Message