OnOpen Code Error

[David Burkhart]

I have an Access 10 (2002/2003?) database that I wrote and split some years
ago. It runs fine on an older PC without problems, but I need to add a new
text box to one form. The PC that I am using to make the change is newer and
includes an evaluation version of Office 2007 (Office/Access 12?). I
installed Access 10 on the newer PC and can open the form and code in design
mode, make the change, save the change, etc just fine.

But, opening the application on the new PC to test the code produces the
error
message "The expression OnOpen you entered as the event property setting
produced the following error. Object or class does not support the set of
events." I did not make any changes to the OnOpen code.

When I look at the References I see that Microsoft Access 12 Object Library
is checked in addition to the Access 10 Object Library. Since the older PC
does not have Office 12 I tried to uncheck that reference, but it won't let
me. I believe the presence of the Access 12 Object Library is causing the
issue.

How do turn off Access 12 so the Access 12 object library does not get
involved in the Access 10 code?

Any help would be appreciated.

 

[Allen Browne]

See:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

 

[David Burkhart]

Allen --

Went to the referenced site. That is precicely the problem I am having only
with XP Pro not Vista. Your clip of the References dialog looks exactly like
mine. I will try the suggestions when I get to my home machine tonight.

Thanks very much for the help. I never would have figured this out by myself.

 

[Allen Browne]

Right, Dave. The same issue can occur on Win XP if you are logged in as a
limited user, not as an Administrator. (It's just that this is not the
default in XP.)