Re: New Error in modules

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 13:49:45 -0500

"Emily8" <Emily8@discussions.microsoft.com> wrote in message
news:2C760FE0-B381-4700-9984-40306E1113FA@microsoft.com
> I have a database that I have been using for about a year. All of a
> sudden I am getting a compile error on the following statement:
>
> Dim dbs As Database
>
> None of the references have changed. Any ideas?

Maybe the actual DAO360.DLL file has been changed or moved. Try opening
the References dialog, unchecking the reference to Microsoft DAO 3.6
Object Library, closing the dialog, reopening the dialog, locating the
reference, and re-checking it.

Note: if you're using Access 97, it would be the DAO 3.51 Object
Library.

It may also be that some other reference has been broken, and that's
keeping the DAO reference from being interpreted. Be sure to look for
any other reference marked MISSING while you're at it. 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

Relevant Pages

  • Re: Late Binding for DAO
    ... If the runtime was created from a database that had the DAO reference set, ... >> <MS ACCESS MVP> ...
    (microsoft.public.access.formscoding)
  • Re: My switchboards wont work with WinXP !
    ... > You do not have a reference set to the ADO object library in this ... > unless of course you have ADO code in your database, ... > The Switchboard form that the wizard made for you uses ADO code ... I did not say to close the database after unchecking DAO. ...
    (microsoft.public.access.forms)
  • cdt glossary 0.1.4
    ... This glossary seeks to limit lengthy misunderstandings ... basic database research and mathematics. ... When context matters, it is provided. ... It is /not/ the same as a reference. ...
    (comp.databases.theory)
  • Re: Do I need to reinstall?
    ... dbOpenDynaset and the Database object are DAO objects. ... you should either remove ADO or explicitly reference you object model: ...
    (microsoft.public.access.reports)
  • Re: Acc2003 Code will not compile
    ... and including Access 97 included a DAO reference by default in new MDBs. ... Access 2000 and Access 2002 don't include that reference by default. ... > Tried to compile in another Acc2000 database for first time in Acc2003, ...
    (microsoft.public.access.modulesdaovba)