New Access 2003 install DAO Feature not available error

[cm26508]

I just installed the MS Office 2003 Pro Suite UPGRADE. I was upgrading from
MS Office Pro XP Developers Kit. All other Office apps work fine except
Access. Everytime I start Access 2003 now it trys to install the DAO Feature
and gets an error trying to find a file. I followed most of the instructions
on the Microsoft Web site about putting in the original CD but the Developers
CD does not have the DAO.msi file so this will still not resolve. Can anyone
help out here?

 

[Allen Browne]

Search your hard disk to see if dao360.dll is already there.

If you find it in
c:\program files\common files\microsoft shared\dao\
you could register it with Windows by opening a command prompt and entering:
regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll"
and it should then work.

If not, open a code window in A2003, and choose References from the Tools
menu.
Deselect MS DAO 3.6.
Close Access.
Then open Access and select the library again.

 

[cm26508]

Thanks Allen. I tried both and neither worked, I still get the same messages
when starting Access 2003????

 

[Allen Browne]

Did you find the file?

Try unregistering it with regsvr32 /u
Then register it again.

BTW, are you logged in as local administrator, or as a limited user?

 

[cm26508]

OK, I unregistered it and went and looked and I have a 3.5 registered
already. Allen, my "Installed Programs" shows 2 "DAO" components (both ATI)
and one "DAO 3.5" component. Not sure if that has anything to do with
anything or not.

btw, I am a local administrator.

 

[Charlie Hoffpauir]

Thanks Allen. I tried both and neither worked, I still get the same messages
when starting Access 2003????

I just want to mention that I am getting exactly the same error on an
install of Access 2000 on a new computer (didn't have this problem on
the old computer which was running win 98. The new computer is Win XP
Pro). So I'll be following the thread with great interest. I might
mention, however, that after the error message, Access seems to work
just fine.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[Allen Browne]

Installed programs? In the Windows Control Panel?

We need to you open a code window in Access, choose References on the Tools
menu. Then deselect any references you don't need. You may be able to get it
down to just three (Access, VBA, and DAO).

Local admin is good.

 

[cm26508]

OK Allen, this is weird... I stepped away with access shutdown for awhile
after I had reregistered DAO360.dll and now it works. DAO 3.6 is registered
as is DAO 3.5, I also have DAO 3.6 selected in the References Window of Code
Builder. Could there have been something that Access was leaving in cache
that needed to be flushed before the registering/unregistering would work?

Thanks!

 

[Allen Browne]

Okay, re-registring the library has solved the problem.

Restarting Access after deselecting, reregistering, and reselecting could
have affected that.