Error Occurs in different PC

[Guest]

I have developed the access program and run sucessfully in diffierent PCs.
But when I copied to one PC and executed the access program. The following
error is occurred:

'the expression on load you entered as the event property setting produced
the following error; A problem occurred while Microsoft Access was
communicating with the OLE server or ActiveX Control'

Pls Help!!

Thanks & Regards,
Jason.

 

[Stefan Hoffmann]

hi,

'the expression on load you entered as the event property setting produced
the following error; A problem occurred while Microsoft Access was
communicating with the OLE server or ActiveX Control'

Run an Office repair installation. If you are using external ActiveX
controls, register them manually.


mfG
--> stefan <--

 

[Guest]

Hi stefan,

Thank you very much for your reply!!

How do I know what external ActiveX controls that I have used ?

Best Regards,
Jason

 

[Peter Yang [MSFT]]

Hello Jason,

You may want to check the the reference of the database, and usually
following components shall be checked.

-Visual Basic for Applications
- Microsoft Access 11.0 Object Library
- Microsoft DAO 3.6 Object Library
- Microsoft Visual Basic for Applications Extensibility 5.3
- OLE Automation
- Microsoft ActiveX Data Objects 2.8 Library

Also, as Stefan mentioined, you may want to repair or reinstall Office
program to see if this fixes the problem.

In addition, you may want to temporarily set Macro Level security to LOW to
see if this is helpful. To isolate the database problem, please let me know
if the issue occurs with a new database. If not, you may want to import
objects to the new database to see which object causes the problem, and
this may lead to the Form/Activex control that is relavant.

If the issue persists, please let me know the OS of the machine. Did you
install the latest service pack on the machine? If you have other related
information, please also let me 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.