Connecting Tech Pros Worldwide Help | Site Map

Error message when opening a database

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 02:56 PM
Ray
Guest
 
Posts: n/a
Default 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



  #2  
Old November 13th, 2005, 02:56 PM
pietlinden@hotmail.com
Guest
 
Posts: n/a
Default 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.

  #3  
Old November 13th, 2005, 02:57 PM
Tom van Stiphout
Guest
 
Posts: n/a
Default 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]

  #4  
Old November 13th, 2005, 02:57 PM
Ray
Guest
 
Posts: n/a
Default 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]


  #5  
Old November 13th, 2005, 02:57 PM
Ray
Guest
 
Posts: n/a
Default 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]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.