Ado & dao

ahrouhi

New member
Local time
Today, 19:39
Joined
Nov 28, 2009
Messages
2
Since Access 97, i learnt to use DAO engine coding in my modules . it is as you know like below:
dim db as database
dim rs as recordset
set db= currentdb
set rs= db.openrecordset(""...)
rs.edit
.
.
.
when i use such coding in access 2003 , i should do some changes in Activex setting and select DAO in upper list. am i right?
for this reason i cant make MDE file in access 2003? if so what sould i do to make mde file.
by the way if i use DAO coding in access 2003 , does it make any problem in migration to 2007?

i would be pleased somebody , professionally explain the above mentined problem and ADO and DAO in Access 97, 2003 and 2007
 
The default library in ac2003 was ADO while ac97 was DAO. You need to go into the references and *uncheck* ADO (ActiveX) and check DAO. It helps to disambiguate your Dim statements as well, ie: Dim db As DAO.Database
The default in ac2007 is back to DAO.
 
once you have set the referecne to DAO, you can then make an mde
 

Users who are viewing this thread

Back
Top Bottom