Help!
This has happened several times, and I still don't know why.
I try to
dim myvar as Database
and in some of my apps, Access gives me a "type not recongnized" error on the "Database" type.
Some of my apps are already using the Database type and it's working fine, so I've been copying working apps to keep the structure, importing everything from the non-working one, and it works fine! So I'm guessing it's probably a simple setting...
But which one? What could cause Access not to recognize something apparently as basic as "Database"?
Thanks for the help!

Make sure you have a reference to DAO 3.60 in menu tool-references dialog

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"audreybmorin" <(E-Mail Removed)> wrote in message
news:48D27EB1-B6E1-412A-9C8F-(E-Mail Removed)...
> Help!
> This has happened several times, and I still don't know why.
> I try to
> dim myvar as Database
> and in some of my apps, Access gives me a "type not recongnized" error on
the "Database" type.
> Some of my apps are already using the Database type and it's working fine,
so I've been copying working apps to keep the structure, importing
everything from the non-working one, and it works fine! So I'm guessing it's
probably a simple setting...
> But which one? What could cause Access not to recognize something
apparently as basic as "Database"?
> Thanks for the help!

I can't find a menu tool-references dialog... I have Access in French so that might be the problem. You do mean the Files, Edit..., Tools menu, right? The only thing that looks like a list of references in there is the ActiveX controls dialog. Is that what you meant? If so, I don't have anything listed as DAO even in my apps that do recognize the "Database" type.

Sorry, I'm good at SQL, I manage with VB, but I'm really not that good with Access itself... :-(

"Alex Dybenko" wrote:

> Make sure you have a reference to DAO 3.60 in menu tool-references dialog
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
> "audreybmorin" <(E-Mail Removed)> wrote in message
> news:48D27EB1-B6E1-412A-9C8F-(E-Mail Removed)...
> > But which one? What could cause Access not to recognize something
> apparently as basic as "Database"?

open any module, create a new one if you have to. There is tool/Reference
menu where you can choose DAO


"audreybmorin" <(E-Mail Removed)> wrote in message
news:1DE8D2E8-8DEC-4270-A21E-(E-Mail Removed)...
> I can't find a menu tool-references dialog... I have Access in French so
that might be the problem. You do mean the Files, Edit..., Tools menu,
right? The only thing that looks like a list of references in there is the
ActiveX controls dialog. Is that what you meant? If so, I don't have
anything listed as DAO even in my apps that do recognize the "Database"
type.
>
> Sorry, I'm good at SQL, I manage with VB, but I'm really not that good
with Access itself... :-(
>
> "Alex Dybenko" wrote:
>
> > Make sure you have a reference to DAO 3.60 in menu tool-references
dialog
> >
> > --
> > Alex Dybenko (MVP)
> > http://Alex.Dybenko.com
> > http://www.PointLtd.com
> >
> > "audreybmorin" <(E-Mail Removed)> wrote in message
> > news:48D27EB1-B6E1-412A-9C8F-(E-Mail Removed)...
> > > But which one? What could cause Access not to recognize something
> > apparently as basic as "Database"?
>

Found it!
The Reference menu is enabled in my working apps, and disabled (greyed out) in my non-working ones, so I can't enable DAO!
Now to figure out which setting disables/enables it...

"Phil Hunt" wrote:

> open any module, create a new one if you have to. There is tool/Reference
> menu where you can choose DAO

It's only enabled when you're in a module (or the Debug window) and not in
debug mode.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"audreybmorin" <(E-Mail Removed)> wrote in message
news:27F323E3-B445-4234-BAC4-(E-Mail Removed)...
> Found it!
> The Reference menu is enabled in my working apps, and disabled (greyed
out) in my non-working ones, so I can't enable DAO!
> Now to figure out which setting disables/enables it...
>
> "Phil Hunt" wrote:
>
> > open any module, create a new one if you have to. There is
tool/Reference
> > menu where you can choose DAO
>