Missing DAO350.DLL

[Monique]

I converted a database from Access 97 to Access 2003 and I am getting a
pop-up in Access 2003 about a broken or missing reference to dao350.dll. My
references in the tools menu is faded and cannot be accessed to correct the
error. What do I do next?

 

[Allen Browne]

1. Create a new (blank) database in Access 2003.

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

3. Open the code window. Deselect all references except these 3:
Access
VBA
Microsoft DAO 3.6.

4. Import everything from your Access 97 database:
File | Get External | Import.

For information about the references for each verson of Access:
http://allenbrowne.com/ser-38.html

 

[Douglas J Steele]

First of all, Access 2003 needs dao360.dll, not dao350.dll

When you say you can't get to the References option under Tools, are you in
the VB Editor when you're trying? If you are, make sure that no code is
currently running (you may have to click on End under the Run menu)

 

[Monique]

Thanks to both of you who responded. I was able to work through my problem
while waiting for and answer. I closed the visual basic window and opened
the form in design view. From there I went to view code and was able to view
the references. I did not have the DAO 3.6 dll; so I did a search and added
it. I'm in the process of testing the database now.