No Database in dropdown

G

Guest

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.
 
J

Jeff Conrad

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.

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

in message:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top