I just recently upgraded from ACCESS 97 to ACCESS 2002
and am haveing trouble with some of the built in
functions. When I try to set a variable to the DATABASE
object it errors. Any help??

Access97 has the Microsoft DAO Object Library in the References Collection
by default. Access2002 has ADO Object Library by default, NOT DAO which you
need as the Database Object belongs to DAO.

Add the Microsoft DAO Object Library to the References Collection of your
database and if you don't use ADO, remove the ADO Object Library from the
References Collection.

Also, not that both DAO & ADO have objects of the same name but they are not
compatible. When you declare these (e.g Recordset), you should (and in some
cases, must) disambiguate them like:

Dim rst As DAO.Recordset

--
HTH
Van T. Dinh
MVP (Access)



"Chad" <(E-Mail Removed)> wrote in message
news:0dab01c37f58$1721b340$(E-Mail Removed)...
> I just recently upgraded from ACCESS 97 to ACCESS 2002
> and am haveing trouble with some of the built in
> functions. When I try to set a variable to the DATABASE
> object it errors. Any help??

Thanks so very much. I changed it and it works great now.

>-----Original Message-----
>Access97 has the Microsoft DAO Object Library in the
References Collection
>by default. Access2002 has ADO Object Library by
default, NOT DAO which you
>need as the Database Object belongs to DAO.
>
>Add the Microsoft DAO Object Library to the References
Collection of your
>database and if you don't use ADO, remove the ADO Object
Library from the
>References Collection.
>
>Also, not that both DAO & ADO have objects of the same
name but they are not
>compatible. When you declare these (e.g Recordset), you
should (and in some
>cases, must) disambiguate them like:
>
> Dim rst As DAO.Recordset
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>
>"Chad" <(E-Mail Removed)> wrote in message
>news:0dab01c37f58$1721b340$(E-Mail Removed)...
>> I just recently upgraded from ACCESS 97 to ACCESS 2002
>> and am haveing trouble with some of the built in
>> functions. When I try to set a variable to the
DATABASE
>> object it errors. Any help??
>
>
>.
>