EP wrote:
I am fresh in Access and after install my Office 2000 Pro within
Win2003 XP pro, I found that I cannot use the DAO functions. e.g. dim
abc as DAO.Recordset ... etc
How can I install or embed the service?
Thank you!
put it in when the concrete is still wet.
No, just kidding. Open a code window. Go to Tools, References.
Scroll down until you find DAO 3.6. click on it. If you want it to be
the default (instead of ADO), move it above the ADO library in the
list. Otherwise, if you declare a recordset object, like this
dim rs as recordset
you'll get an ADO recordset.
Of course, you could always use the library prefix. then reference
order doesn't matter.
dim rsDAO as DAO.Recordset
dim rsADO as ADODB.Recordset