DAO Error

[Jesse Aviles]

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

 

[Allen Browne]

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.