Access not recognizing Database type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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,
Click to expand...
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
Click to expand...
apparently as basic as "Database"?
 
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... :-(
 
open any module, create a new one if you have to. There is tool/Reference
menu where you can choose DAO


audreybmorin said:
I can't find a menu tool-references dialog... I have Access in French so
Click to expand...
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.
 
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...
 
It's only enabled when you're in a module (or the Debug window) and not in
debug mode.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


audreybmorin said:
Found it!
The Reference menu is enabled in my working apps, and disabled (greyed
Click to expand...
out) in my non-working ones, so I can't enable DAO!
 
Back
Top