Access 2002 (xp) & Access 2007 On Same Machine ?

[janteby]

Hello



I have a machine where Access 2002 (XP) was on & where I designed many applications that were working fine.

I then uninstalled MS Office 2002 but left Access 2002 & then installed MS Office 2007, which included Access 2007. I wanted to have both Access 2002 & 07 on at the same time.

Now when I run any of my Access 2002 MDBs with Access 2002 I get the following error. It happens on every Application & on every Form that has code to it.

"The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."

"The expresssion 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 tried decompiling some of the Apps, Compact & repairing, using brand new blank MDB files & transferring over all objects, all Service packs have been updated, & no matter what I do I cant get rid of that error message, hence none of my apps will work now.

I researched a lot on Google & came across this 1 article: http://allenbrowne.com/bug-17.html

In the article it says under Vista or Windows 7, but even though I have Windows XP Pro, I still tried the solutions & still does not work.

I then un-installed Access 2007, hence leaving just Access 2002 & now my programs work again.

Is their any way to have both 2002 & 2007 on the same machine at the same time & not get the above Error ?

Any help would be greatly appreciated.

Thank you
Jeff

[ssanfu]

I researched a lot on Google & came across this 1 article: http://allenbrowne.com/bug-17.html

Is their any way to have both 2002 & 2007 on the same machine at the same time & not get the above Error ?

So, if you read Allen's article, you know why the error occurs.
I did find something called "Workbench 10 for Microsoft Access" at

http://www.vb123.com/workbench/help/...ml?default.htm

Maybe this will help.