Re: dao problem -- reference libraries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Look at the libraries that Access is referencing

from the menu in a module window --> Tools, References...

uncheck any references that are MISSING and locate replacements if appropriate.

if the DAO by ATI Multimedia is checked, uncheck it and then check a Microsoft DAO Library if you have code that uses DAO.

If in doubt about whether or not you can unceck a library, uncheck it and compile

from the menu: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

if you have an error because you are missing a library reference, go back to Tools, References...,check it, and comile again


Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)


Karamursel wrote:
When I use the Combo Box in my Microsoft Access application I get this message. ERROR 1706 No valid source could be found for product DAO. The Windows Installer cannot continue. I suspect the problem is caused by the program listed below.

I Loaded an ATI Multimedia Program. They installed a program DAO. I tried to remove it in the Add or Remove Program and I get the Error:- 3 Patch Package.
How can I completely remove all ATI programs from my computer. “Add or Remove Programs” wont do it.

.



Relevant Pages

  • Re: HELP!! Strange new error - halting production!
    ... When you move a reference up the list, you are changing its *priority*. ... if 2 libraries have the same object (e.g. ADO and DAO both have a Recordset ... checked to make sure DAO was in the references and it was (3.6 - I'm ...
    (comp.databases.ms-access)
  • Re: Learning to work with recordsets, and failing miserably
    ... My new problem is that I can't get FindFirst to work. ... >> frmSearchResults, allowing focus to return to frmHouseholds. ... ADO and DAO ... >There are other objects that defined in both libraries, ...
    (microsoft.public.access.forms)
  • Re: "If ......Exists.... Then Run SQL code"
    ... It provides all the basics you need, such as loops, branches, types of ... there a dozens of availiable libraries you can add to the basic VBA/Access. ... Microsoft tried introducing ADO instead of DAO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Expression - calculating running total
    ... to understand the basics of coding with VBA (Visual Basic ... DAO refers to the Data Access ... decide which object libraries you want to work with. ... To reference the library you just go to the VBA ...
    (microsoft.public.access.queries)
  • Re: Compile error: User-defined type not defined
    ... and omits a reference to the DAO library. ... > If you are NOT using any ADO code anywhere in your database, ... in your declarations, to ... > This is not so essential for "Database", but both libraries have a ...
    (microsoft.public.access.modulesdaovba)