Can I use DAO in .ADP to SQL Server ?

  • Thread starter Thread starter S.L.
  • Start date Start date
S

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 ?

(if not necessary, It good for me to not waste time to study programming
using ADO)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's the steps to modify a .adp connect string & convert DAO to 2
Converting Application from ADP to ACCDB 11
CurrentDb() in adp file 3
Can I use DAO in .ADP to SQL Server ? 1
Using ADO in an mdb application 106
Tabledefs object (DAO) in a .adp database application 5
Custom Database Properties 2
msjtes40.dll crashes with no DAO reference...... 1

Back
Top