Installation DAO utility

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

[pietlinden@hotmail.com]

Re: Installation DAO utility


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

[EP]

Re: Installation DAO utility

Got it !!! Thousand Thanks ^.^

pietlinden@hotm ail.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