Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

DAO Error

Discussion in 'Information Technology' started by Jesse Aviles, Nov 16, 2005.

Tags:
  1. Jesse Aviles

    Jesse Aviles
    Expand Collapse
    Guest

    Recently, I upgraded my computer hardware and did a clean install. After
    installing Office XP (I have been using the same copy of XP for the last
    four years), when I'm using the wizards in Access (Linked database manager,
    command button wizard, etc.) a box opens telling me that DAO is being
    installed, then it fails because it wasn't able to fing DAO. I tried
    reinstalling Access again with no success. This happens everytime and
    although I can cancel it with no troubles, its getting to be annoying.
    Meanwhile, is there a way to change the way that Access adds default code?
    I dont like the naming conventions Access uses for declarations and error
    handlers, besides some of the code it uses is old and even in the help file
    says to use updated code. Thanks.

    Jesse Aviles
    m o n k @ c o q u i . n e t
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Make sure you are logged in as a local administrator (not a limited user.)

    Search the hard disk to find the file dao360.dll.

    Open your database, and deselect the Microsoft DAO 3.6 library (Tools |
    References, from a code window.) Make sure Access is not running.

    Unregister this file by opening a command prompt, and entering something
    like this line:
    regsvr32 /u "c:\program files\common files\microsoft
    shared\dao\dao360.dll"

    Restart, and then register the library again:
    regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll"

    Open your database, open a code window, choose References from the Tools
    menu, and select the library again.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Jesse Aviles" <monk@coqui.net> wrote in message
    news:22f91$4379c7ea$42320654$16016@COQUI.NET...
    > Recently, I upgraded my computer hardware and did a clean install. After
    > installing Office XP (I have been using the same copy of XP for the last
    > four years), when I'm using the wizards in Access (Linked database
    > manager, command button wizard, etc.) a box opens telling me that DAO is
    > being installed, then it fails because it wasn't able to fing DAO. I
    > tried reinstalling Access again with no success. This happens everytime
    > and although I can cancel it with no troubles, its getting to be annoying.
    > Meanwhile, is there a way to change the way that Access adds default code?
    > I dont like the naming conventions Access uses for declarations and error
    > handlers, besides some of the code it uses is old and even in the help
    > file says to use updated code. Thanks.
    >
    > Jesse Aviles
    > m o n k @ c o q u i . n e t
     

Share This Page