OLE Server - Active X Controls - Connection

[Maritza]

I developed an Access 2000 DB which is being use by aprox 40 users. The DB is on a NT network server. This DB has work without problems for around two months an suddently I have 2 users experiencing problems. This is the error that we get:

"The expression On Open you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or Active X Control.
* 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 evaluating the function, event, or macro.


I placed a pause in the Main Menu form, Open Event where I have the following command;

Set con1 = Application.CurrentProject.Connection

when it tries to assigned the CurrentProject connection to the variable I get the following message:

Runtime error -2147024770(8007007e) The specified module could not be found.

con1 is defined in a module where I define all my variables with the following syntax. All the references are set up the same.

Public con1 As ADODB.Connection

Does any one have any idea what could be causing this problem. Is there a particular system set up that can be causing this problems?

Thanks,

Maritza

 

[bjackson]

Have You recently changed or installed Norton anti virus?
Sometimes norton will cause that error message

 

[heller]

same problem

I have the same problem here on my database, but just with chinese windows and english access. And no Norton Anti Virus installed. Anybody who knows more?

 

[Mr.Lover23]

Same problem...is therere somebody that can help PLS?????

I have eben tried to reinstall the office, to switch off the norton anti virus but nothing....

any idea

 

[Mr.Lover23]

Hey i found the problem!!!

At least it worked for me. The only problem was regional coding. Under languages for non-unicode programs!!! In basic some letters was changed due to this.

Ceers

 

[paulcraigdainty]

Same problem

Hi

I'm having the same problem.

I have the following code behind a command button:

Private Sub cmdUpdate1_Click()

DoCmd.Close
DoCmd.OpenForm "frmUpdateQuestion1"

End Sub

When i click the button I receive the following error msg:

"The expression On Click you entered as the event property setting produced the following error: A Problem occured while MS Office Access was communicating with the OLE server or ActiveX control."

The weird thing is that I have another database which I created sometime ago which uses the same code and doesn't display the error.

Has anyone any ideas??