Missing or broken reference to the file 'DA0350.DLL' version 5.0

[Dean]

I have one user that is trying to access a database and we keep getting this
missing or broken reference to the file da0350.dll. None of the other users
are having any problems. We are using office XP. Please help!

Thanks,

Dean

 

[Allen Browne]

In Access 2002, you need a reference to dao360.dll, not dao350.dll.

Open any code window (press Ctrl+G) and choose References on the Tools menu.
Uncheck the box beside:
Microsoft DAO 3.5 Library
and check the box beside:
Microsoft DAO 3.6 Library

More info on the references that apply to each version of Access:
http://allenbrowne.com/ser-38.html

 

[Dean]

I am sorry. The database was written in access 97 and we are using office XP.
I have converted it but than I get a different error. Compile error: Error
loading DLL. I looked for Microsoft DAO 3.6 but all I see is 3.5.

Thanks,

Dean

 

[Allen Browne]

Right, the Access 97 database would have used dao 3.5. After converting to
Access 2000 or later, you need to use DAO 3.6 instead.

The file will be on your drive if you ran a normal install of Access. If it
is not available, then:
1. Under Tools | References in a code window of your database, remove the
3.5 reference. Close Access.

2. Make sure you are logged in to your computer as an Administrator (not a
limited user.)

3. Locate dao36.dll on your hard disk. Unregister it by entering something
this at the command prompt:
regsvr32 /u "c:\program files\common files\microsoft
shared\dao\dao360.dll"

4. Re-register the library again:
regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll"

5. Open your application, open the code window, choose References on the
Tools menu. "Microsoft DAO 3.6 Library" should now be available.

 

[Dean]

It will not let me unregister or register dao360.dll. Can't find in library
error. But I can drill down to the file and see it. Have any other
suggestions?

Thanks,

Dean

 

[Allen Browne]

Reinstalling Microsoft Office should also cause the library to re-register
if you would prefer to do it that way.

 

[Dean]

I have reinstalled office 4 times now. No luck. Any other suggestions?

Thanks,

Dean

 

[Allen Browne]

Did you try uninstalling Office first?

Dean, you have already confirmed that the problem is the library is not
registered. Registering the library will be the easiest solution. If you
can't do that, and reinstalling Office does not work then trashing your
drive and starting a new install of Windows would probably work.