I usedWindowXp andMicrosoft
Office Professional 2003 before, then changed toWindow 7 and
Microsoft Office Professional 2010 last month, error message appeared when I wanted to update the data base in
Access file:
The expression Before Update 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.
* 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 clicked"Help" the following message came out :
"This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when
the event occurs."
Please help me to solve this problem.