Error message when opening a database

I am running a database on a file server from a pc operating Windows XP Pro.
MS Office 2003 is used. When I open the database, below error message
appears.

The expression On Click you entered as the event property setting produced
the following error: A problem occurred while Microsoft Office Access was
communicating with the OLE server or ActiveX Control.

It happens on certain pcs only, not all pcs. Some work perfectly well. Any
guidance to trace the possible causes is appreciated.

Ray

re: Error message when opening a database

sounds like the control is registered on only some of the machines. If
you register it, your code will work. Another reason not to use
ActiveX controls if you can help it.

re: Error message when opening a database

On 25 Oct 2005 09:46:19 -0700, pietlinden@hotmail.com wrote:

This may help: using the developer edition of Access (I can never
remember what it's called), create a setup program using the Package &
Deployment wizard. It should package the ActiveX controls as well, and
install them on the user's PC if not yet there or out of version.

-Tom.

[color=blue]
>sounds like the control is registered on only some of the machines. If
>you register it, your code will work. Another reason not to use
>ActiveX controls if you can help it.[/color]

re: Error message when opening a database

Pietlinden,

Which controls are you referring to?

Ray

<pietlinden@hotmail.com> wrote in message
news:1130258779.030900.280100@g49g2000cwa.googlegr oups.com...[color=blue]
> sounds like the control is registered on only some of the machines. If
> you register it, your code will work. Another reason not to use
> ActiveX controls if you can help it.
>[/color]

re: Error message when opening a database

Tom,

I do not have developer edition of Access and just have Office 2003 Pro.

Ray

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:kg2ul1hui60not4m0ioebe8kj0sp1u7ki1@4ax.com...[color=blue]
> On 25 Oct 2005 09:46:19 -0700, pietlinden@hotmail.com wrote:
>
> This may help: using the developer edition of Access (I can never
> remember what it's called), create a setup program using the Package &
> Deployment wizard. It should package the ActiveX controls as well, and
> install them on the user's PC if not yet there or out of version.
>
> -Tom.
>
>[color=green]
>>sounds like the control is registered on only some of the machines. If
>>you register it, your code will work. Another reason not to use
>>ActiveX controls if you can help it.[/color]
>[/color]