MISSING Reference in Microsoft Access

[Jason]

When I start my Access Database, Visual Basic IDE, it gave me a error message
"Error in loading DLL".

When I open my switch board with event procedure, it gave me a error message,

The expression On Click you entered as the event property setting produced
the following error: The expression you entered has a function name that
Microsoft Access can't find.
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluting the function, event, or macro.

How do I go about solving it?

 

[Peter Yang[MSFT]]

Hello Jason,

If the issue occurs on different client machines, you may want to check
modules/macro to see if there are duplicated function names. Also, modules
cannot have the same name as functions or subs.

If the issue only occurs on this machine, please run "regsvr32
<<Dao360.dll_Path>> " to see if it helps.

833220 "Error in loading DLL" error message when you run a Microsoft Access
wizard in Access 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;833220

If you have any update, please feel free to let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jason]

Hi Peter,

I try this method.
But the funny thing I saw is that,
It only happen in Windows XP machine. While Windows 2000 work totally find.
I got 3 windows 2000, 3 windows XP.

The problem occur for the MSOWC.dll file.
Office Web Component 9.0.

I could on the access on the 3 windows 2000. But once I switch on at the XP
machine, it cant open. Although, the MSOWC.dll file is located in the same
place as the other machine. The file is there, when i attempt to browse the
file, it located, but it still display the MISSING message.

 

[David Benyo via AccessMonster.com]

Jason,

See if this helps: Open the database, hit alt-F11 to open VBA. Click Tools ->
References. Uncheck the "Missing" reference. Click OK. Click Tools ->
References. Find the reference that used to be missing and check it off.

You'll have to do this on each PC that an error is occurring.

I've run into this problem with A2007 when A2003 users try to open a DB. Not
a big deal with small applications in small environments, but a bit annoying.

Good luck.

Hi Peter,

I try this method.
But the funny thing I saw is that,
It only happen in Windows XP machine. While Windows 2000 work totally find.
I got 3 windows 2000, 3 windows XP.

The problem occur for the MSOWC.dll file.
Office Web Component 9.0.

I could on the access on the 3 windows 2000. But once I switch on at the XP
machine, it cant open. Although, the MSOWC.dll file is located in the same
place as the other machine. The file is there, when i attempt to browse the
file, it located, but it still display the MISSING message.

Hello Jason,

[quoted text clipped - 34 lines]

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jason]

Hi David,

I tried to uncheck. It will prompt a "Error loading DLL" message. I guess my
DB has code using the DLL file. Thus causing it unable to unload it.

I uncheck and click ok. It show me the error then when I go back and look at
it. It is still there. It just won't go off.

Thanks and Best Regards

Jason,

See if this helps: Open the database, hit alt-F11 to open VBA. Click Tools ->
References. Uncheck the "Missing" reference. Click OK. Click Tools ->
References. Find the reference that used to be missing and check it off.

You'll have to do this on each PC that an error is occurring.

I've run into this problem with A2007 when A2003 users try to open a DB. Not
a big deal with small applications in small environments, but a bit annoying.

Good luck.

Hi Peter,

I try this method.
But the funny thing I saw is that,
It only happen in Windows XP machine. While Windows 2000 work totally find.
I got 3 windows 2000, 3 windows XP.

The problem occur for the MSOWC.dll file.
Office Web Component 9.0.

I could on the access on the 3 windows 2000. But once I switch on at the XP
machine, it cant open. Although, the MSOWC.dll file is located in the same
place as the other machine. The file is there, when i attempt to browse the
file, it located, but it still display the MISSING message.

Hello Jason,

[quoted text clipped - 34 lines]

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Yang[MSFT]]

Hello Jason,


You may try to run

regsvr32 "<path>\msowc.dll" to see if it helps.

If there is any update, please feel free to let's know. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jason]

Hi Peter,

Tried. No different. =)

Is this a funny problem?

Thanks and Best Regards

 

[Peter Yang[MSFT]]

Hi Jason,

Please try to search msowc.dll on the machine and if there are multiple
files, please temporarily rename others and keep one only.

Also, what's the versioin of the file?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.