When I try setting up the Dim statement for a database object, I do not have
the database object in my list of available objects.

I think I need additional files installed, but can not find them on disk one
of the Office 2000 disk. Is this info on Disk 2?

You just need to set a reference to the DAO library (it's not set by default
in ACCESS 2000 and 2002). Open Visual Basic Editor, click Tools |
References, and select the Data Access Object library (3.6).

Note that DAO and ADO have some objects with the same names (e.g.,
Recordset), so disambiguate any DAO objects using DAO. in the declaration.
--

Ken Snell
<MS ACCESS MVP>




"Cyberwolf" <(E-Mail Removed)> wrote in message
news:C0E3C5C1-B38A-44A3-A203-(E-Mail Removed)...
> When I try setting up the Dim statement for a database object, I do not
> have
> the database object in my list of available objects.
>
> I think I need additional files installed, but can not find them on disk
> one
> of the Office 2000 disk. Is this info on Disk 2?

Thanks Ken That is exactly what I was looking for. I am an Office 97 user
and I never had to do that. Now I know for future use.

"Ken Snell [MVP]" wrote:

> You just need to set a reference to the DAO library (it's not set by default
> in ACCESS 2000 and 2002). Open Visual Basic Editor, click Tools |
> References, and select the Data Access Object library (3.6).
>
> Note that DAO and ADO have some objects with the same names (e.g.,
> Recordset), so disambiguate any DAO objects using DAO. in the declaration.
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
>
>
> "Cyberwolf" <(E-Mail Removed)> wrote in message
> news:C0E3C5C1-B38A-44A3-A203-(E-Mail Removed)...
> > When I try setting up the Dim statement for a database object, I do not
> > have
> > the database object in my list of available objects.
> >
> > I think I need additional files installed, but can not find them on disk
> > one
> > of the Office 2000 disk. Is this info on Disk 2?
>
>
>