Error in Access 2003 (Updated)

[Guess Who]

I get this error message in Access 2003 :Your Microsoft Office Access
database or project contains a missing or broken reference to the file
DAO350.dll version 5.0 anyone else had this problem?
Thanks in advance for any help

 

[Douglas J. Steele]

Access 2003 (and 2002 and 2000, for that matter) all require DAO360.dll, not
DAO350.dll. With any module open, select Tools | References from the menu
bar. Unselect the reference to Microsoft DAO 3.5x Object Library, scroll
down until you find Microsoft DAO 3.6 Object Library, select it and close
the dialog.

 

[Guess Who]

By module do you mean a database?

 

[John Vinson]

By module do you mean a database?

No. Open the database, and select the Modules tab; or, easier, just
type Ctrl-G to open the VBA editor window. Then you can select
Tools...References.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guess Who]

When I do that the references is grayed out, and also when I use
Ctrl-G I get a box that opens at the bototm that says immediate. This
doesn't seem to be working. Any other options

 

[Douglas J. Steele]

Sounds as though you've got code running. In the middle of the button bar
under the menu bar, is the black square ("End") enabled? If so, click on it
to stop all code from running, then try the Tools | References again.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

 

[Guess Who]

This isn't working

 

[John Vinson]

This isn't working

"Doctor, I don't feel good. What should I take?"

Please explain a) *what* you are doing, in detail; and b) *how* it's
not working.

Douglas is *very* good with Access. However, neither he nor any of us
are telepathic, and we cannot see your database. Please meet us
halfway.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guess Who]

This is hard to explain but I will try ( and I know you guys are good
at what you do) I downloaded the inventory database from the Microsoft
access website and that is what I am using. When I open the database
it comes up with the error about the broken or missing reference to
DAO350.dll so I click "OK", then a window comes up with the error
labeled Microsoft Visual Basic at the top with the message Compile
Error, can't find message or library.I then click "OK" and there are 2
windows open yet, inventory - Form_Switchboard Code and inventory -
Form_Products Code. If I go to tools : references is grayed out. This
is where I get confused as what to do. I hope this helps as this is
the best I can explain it. Thanks again

 

[Douglas J. Steele]

See whether clicking on Run | End helps.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[John Vinson]

This is hard to explain but I will try ( and I know you guys are good
at what you do) I downloaded the inventory database from the Microsoft
access website and that is what I am using. When I open the database
it comes up with the error about the broken or missing reference to
DAO350.dll so I click "OK", then a window comes up with the error
labeled Microsoft Visual Basic at the top with the message Compile
Error, can't find message or library.I then click "OK" and there are 2
windows open yet, inventory - Form_Switchboard Code and inventory -
Form_Products Code. If I go to tools : references is grayed out. This
is where I get confused as what to do. I hope this helps as this is
the best I can explain it. Thanks again

Try holding down the Shift key while you're opening the database. This
will prevent the Startup code from running (no forms should be open;
close them if they do open). Then press Ctrl-G to bring up the VBA
editor. Is Tools... References still greyed out?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guess Who]

After pressing control-g a window at the botom comes up with the word
immediate on it and tools:references is grayed out

 

[Guess Who]

I used run:reset and then references show up under tools menu. There
are 5 items checked and they are as follows:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
Missing:Microsoft DAO 3.51Object Library
OLE Automation
Microsoft Visual ApplicationsExstensibility 5.3

Thanks for your help.

 

[Guess Who]

I used run:reset and then references show up under tools menu. There
are 5 items checked and they are as follows:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
Missing:Microsoft DAO 3.51Object Library
OLE Automation
Microsoft Visual ApplicationsExstensibility 5.3

Thanks for your help.

 

[John Vinson]

I used run:reset and then references show up under tools menu. There
are 5 items checked and they are as follows:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
Missing:Microsoft DAO 3.51Object Library

THAT'S the problem.

Uncheck it; scroll down and you should find an unchecked box for
Microsoft DAO 3.6 Object Library.

Check it.

OLE Automation
Microsoft Visual ApplicationsExstensibility 5.3

Thanks for your help.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guess Who]

THAT'S the problem.

Uncheck it; scroll down and you should find an unchecked box for
Microsoft DAO 3.6 Object Library.

Check it.

There is no reference to DAO 3.6 Object Library

 

[John Vinson]

There is no reference to DAO 3.6 Object Library

Then check the highest numbered DAO Object Library. 3.6 should have
been installed with Office XP or Office 2003 - you may need to
reinstall.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guess Who]

Then check the highest numbered DAO Object Library. 3.6 should have

been installed with Office XP or Office 2003 - you may need to
reinstall.

There is no DAO listed at all, how is the best way to re-install DAO?
Thanks for your help

 

[Guess Who]

Then check the highest numbered DAO Object Library. 3.6 should have

been installed with Office XP or Office 2003 - you may need to
reinstall.

There is none listed but after searching there is a dao360.dll in
c:\programfiles\commonfiles\microsoft\shared\dao does this help or do
I need to re-install?
Thanks again

 

[Douglas J. Steele]

There is none listed but after searching there is a dao360.dll in
c:\programfiles\commonfiles\microsoft\shared\dao does this help or do
I need to re-install?
Thanks again

Try registering it using regsvr32.exe

Check http://support.microsoft.com/?kbid=161983 if you're not familiar with
regsvr32.exe