Access 2000 compatible wtih 2002?

  • Thread starter Thread starter Mercy
  • Start date Start date
M

Mercy

I recently upgraded to Office XP.

When I opened my project (implemented through Access
2000) in Access 2002, and then tried to open a form I got
the following message:

The expression On Current you entered as the event
property setting produced teh 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,
teh name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function,
event, or macro

In my case ... the event procedure is not running. I
checked ... the event procedure is still there ... and it
is still called for. But when the event (On Exit) that
should set off the procedure happens... I get the same
message except it now starts with:
The expression On Exit blah blah blah

Can anyone explain please?
Thanks,
Mercy
 
It may very well be that you've lost a reference to an OLE object in the
database. In that case you'll either need to delete and recreate the object
in your current version, or re-register the OLE server and reset the
reference. Do that with:

Start ... Run ...

regsvr32.exe "C:\Path to the OCX or dll"

You'll get a message back that the registration succeeded. If necessary also
reset the reference by going to a code window and using the menu:

Tools ... References

then finding and resetting the missing reference.

There is also a bug in Norton antivirus that can cause this error to happen
in Access:

http://support.microsoft.com/default.aspx?scid=kb;en-us;295824
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Mercy said:
I recently upgraded to Office XP.

When I opened my project (implemented through Access
2000) in Access 2002, and then tried to open a form I got
the following message:

The expression On Current you entered as the event
property setting produced teh 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,
teh name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function,
event, or macro

In my case ... the event procedure is not running. I
checked ... the event procedure is still there ... and it
is still called for. But when the event (On Exit) that
should set off the procedure happens... I get the same
message except it now starts with:
The expression On Exit blah blah blah

Can anyone explain please?
Thanks,
Mercy
Click to expand...
 
Access 2002 uses the same file format by default as Access 2000. You can run
apps created in Access 2000 under Access 2002 (or Access 2003) and provided
you use the default Access 2000 format and avoid new features that were not
supported in the earlier version, you can run apps created in Access 2002
(or Access 2003) under Access 2000.

In my experience, the error message you're seeing is usually caused by a
corrupted form. In fact, while I can't rule out the possibility that there
may be other causes of that error message, I have never personally
encountered one. Whenever I have seen that error message, it has always been
caused by a corrupted form.

This can usually be fixed by creating a new, empty MDB or ADP, and importing
all of the objects from the old one. Very occasionally, I have seen
situations where all the objects except the corrupted one could be imported,
and the corrupted object had to be either imported from an older backup copy
or, in the absence of a backup, rebuilt, but (again, in my experience) that
is quite rare - importing usually fixes the corruption.
 
Back
Top