VBA broken in Access 2003 after installing Access 2007?

[viritrilbia]

After installing Access 2007, some of my Visual Basic procedures don't appear
to work any more in Access 2003. These are in mdb files that have never been
opened in Access 2007. The particular error message I am getting is

"Run-time error '459':
Object or class does not support the set of events"

This happens when I run a procedure that sets the RecordSource property of a
Form. Any ideas what's wrong and how I can fix it? Thanks!

 

[Pete D.]

Check for missing reference to ADO most likely. But it sounds like a
reference missing.

 

[boblarson]

Also, you aren't by chance using Windows Vista are you?
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Pete D.]

Bob,
I haven't had the Vista pleasure yet, curious why you ask the question.
Pete D.

 

[boblarson]

The reason I asked is because when using multiple versions of Access with
Windows Vista, you need to set your MSAccess.exe file to run as administrator
or else it can't make the necessary registry changes to move between versions.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Pete D.]

Thanks, Duff

The reason I asked is because when using multiple versions of Access with
Windows Vista, you need to set your MSAccess.exe file to run as
administrator
or else it can't make the necessary registry changes to move between
versions.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[viritrilbia]

No, I'm using Windows XP.

Also, you aren't by chance using Windows Vista are you?
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[viritrilbia]

I'm not sure what you're telling me to do. Can you be more explicit? The
VBA code itself is unchanged, and worked fine in Access 2003 before I
installed Access 2007.

 

[Pete D.]

Open up the module in the code window. Select TOOLS, REFERENCES. Look for
one with a check mark listed as MISSING. Write it down then unselect the
check box. Find the same reference for it except now that your in 2007 it
may be a different version. Select it and compile/save. Test, your problem
should be gone. In 2007 ADO is no longer the default DAO is so I suspect
with the error your getting this is the problem but could be any one of the
references. V/R Pete D.