With Access 2003, you should probably be using OWC11.DLL, not OWC10.DLL.
First, find these libraries on your hard drive. The default locations are:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10\OWC10.DLL
C:\Program Files\Common Files\Microsoft Shared\Web Components\11\OWC11.DLL
Next, open the References dialog window and check the path and file name of
the "MISSING:" Reference and compare whether it is the same as the file on
your hard drive. If they are, then remove the "MISSING:" Reference from the
list by unchecking the check box. Close the References dialog window and
attempt to compile the code. If it compiles without errors then you didn't
need this Reference and you're okay.
If you get a compile error, then open the References dialog window again and
try browsing to and adding the OWC11.DLL Reference. Close the References
dialog window again and attempt to compile the code. If unsuccessful, open
the References dialog window again and remove the OWC11.DLL Reference and add
the OWC10.DLL Reference. Close the References dialog window again and
attempt to compile the code.
If none of these steps work, then you may need to reregister libraries.
Start with the OWC10.DLL and OWC11.DLL libraries. To do so, type the
following in the Windows Start -> Run dialog window (watch out for word wrap,
as this is all one line):
Regsvr32.EXE "C:\Program Files\Common Files\Microsoft Shared\Web
Components\10\OWC10.DLL"
.. . . and then:
Regsvr32.EXE "C:\Program Files\Common Files\Microsoft Shared\Web
Components\10\OWC11.DLL"
If your files are in a different directory, then use your own directory
path, not this default one. After reregistering the libraries, attempt to
remove the "MISSING:" Reference, close the References dialog window again and
attempt to compile the code, then attempt to add the Reference again and then
recompile the code.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
