Why can't I use Database object in code?

[RBohannon]

Can anyone tell me why I can use
Dim dbs As Database
in a sub or function in a module?

I get an compile error pointing to this line saying "user-defined type
not defined."

The auto-complete doesn't even have Database as a choice. It begins
with DataAccessPage.

Thanks for any response.

[Anne Nolan]

Go to Tools.. References and make sure DAO is checked.

Anne

"RBohannon" <ra*****@hotmail.com> wrote in message
news:ad**************************@posting.google.c om...

Can anyone tell me why I can use
Dim dbs As Database
in a sub or function in a module?

I get an compile error pointing to this line saying "user-defined type
not defined."

The auto-complete doesn't even have Database as a choice. It begins
with DataAccessPage.

Thanks for any response.

[Larry Linson]

"Anne Nolan" <an***************@AOL.COM> wrote in message
news:2l************@uni-berlin.de...

Go to Tools.. References and make
sure DAO is checked.

And, be sure to qualify the references to objects that are common to ADO and
DAO, for example:

Dim rs as DAO.Recordset
Dim qd as DAO.QueryDef

You may, but don't have to qualify the Database object, as there is no such
object in ADO. I use the qualifying DAO.Database just for clarity for anyone
who comes along to maintain the database after me.

Larry Linson
Microsoft Access MVP

[RBohannon]

Thank you both. Your help is much appreciated.

Randy