No Database in dropdown

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAVIDTHO - 07 Feb 2006 19:30 GMT

I want to begin coding with "Dim dbs as Database". In some instances of
Access 2000 that I have made in the past, in Code Builder after typing "Dim
dbs as" there is a drop down that includes "Database" and one can proceed.
But recently in the drop down there are many entries but not "Database", and
typing in database causes an error. I am not aware of any changes I have
made in Access to cause this to happen. The only solution is to take a
previous instance that does work, clean out all the data and begin with this
as a "new" instance.
I find this inexplicable; can anyone help?
Thank you.

Reply to this Message

Jeff Conrad - 07 Feb 2006 21:00 GMT

Database is a DAO object, not ADO, and by default
both Access 2000 and 2002 do not set a reference to
the DAO library.

You need to add a reference to the DAO object library
which would be Microsoft DAO 3.6 Object Library.
Do you know how do that?

If you do not need to use ADO, then just uncheck that
reference.

Now when you start typing Database will be an option.
Even better would be to fully qualify it like so:

Dim dbs As DAO.Database

Access will be sure to know you are using a DAO object.

Signature

Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

> I want to begin coding with "Dim dbs as Database". In some instances of
> Access 2000 that I have made in the past, in Code Builder after typing "Dim
[quoted text clipped - 6 lines]
> I find this inexplicable; can anyone help?
> Thank you.

Reply to this Message