Microsoft Access 2003: How do you resolve "The expression On Click you entered as the event property setting produced the following error: Object or class does not support the set of events?

Upon working for a company that still uses Access 2003 within a server-client environment in which the data is stored on a Windows Server 2008 R2 Active Directory computer, a client's profile was backed up and stored in a folder share within the same server.  The profile was recreated on the workstation with settings and icons copied over from the folder share to the workstation.  One of the databases was created in Access 2003, but the user also had Access 2013 on their desktop and accidentally brought up the Access 03 created database in Access 13.  After this was done and she tries to click on any interactive button she gets the message:
"The expression On Click you entered as the event property setting produced the following error:  Object or class does not support the set of events".  After this statement, two more statements say after an *.  1. "The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. and 2. There may have been an error evaluating the function, event, or macro.   An OK button appears and the database does not open up after clicking on it.  Can somebody point me to a way to resolve this error?   Does this have to do with compiling the file in some way?
memewarrenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hamed NasrRetired IT ProfessionalCommented:
I assume the client has both. 2003 and 2013 Access.
It is a version compatibility issue.
Options:
1 open mdb file with Access 2003 and continue
2 Convert mdb to accdb format by opening mdb in access 2013 and save it to accdb format. https://support.office.com/en-us/article/convert-a-database-to-the-accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd

But since is accidentally happened option 1 might be the preferred one.
0
PatHartmanCommented:
Are you trying to use A2013 to open the database or A2003 when you get the error?  Most versions of Access will not cohabit easily since they are constantly fighting for control of the registry.  The user MUST have admin permissions for these registry updates to complete correctly or you can end up with a mishmash.

Try opening A2003 and using that to open the database with the problem.  If you still can't open it without error, open any code module in design view and look to see if there are any missing references.  You may have to uninstall A2013 and reinstall 2003 to give A2003 control back.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
Decompile you Access and  recompile it...check for errors
If nothing comes up then take a very good look at the references of your applications...probably there is a version mismatch (even they look identical if a minor version difference can cause havoc...seach for exact dll/ocx...even better to copy from another working installation....Note : first unregister the "bad" ....delete it/rename it...copy the "good"...register it)
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<"The expression On Click you entered as the event property setting >>

 As Pat and John said, it's probably references, although starting with A2007, a lot of syntax checking was tightened up and adjustments may need to be made.

 Simply opening the app and making sure it compiles will tell you quick what the problem is.

  Also at issue can be the "bitness".  A2003 is strictly 32 bit, where A2013 can be 32 or 64 bit.   Depending on the app (if it makes API calls), it would break it.

Jim.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.