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
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