By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Installation DAO utility

P: n/a
EP
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!

Jul 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

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

Jul 28 '06 #2

P: n/a
EP
Got it !!! Thousand Thanks ^.^

pi********@hotmail.com wrote:
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
Jul 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.