reference vba 2003 vs 2007

  • Thread starter Thread starter patti
  • Start date Start date
P

patti

i have started getting error:
"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."

Access 2007 was recently put on my pc in addition to access 2003.
My references list Microsoft Access 12.0 Objects. Should this be version 11.0?
If so, do i need to delete 12.0 to add 11.0?

i am just learning about VBA references - because i started having problems
with a database. issues always lead to insight for me.

thanks.
 
Hi Patti

Yes, this is a known problem.

Access 2003 was released before Vista was conceived, and therefore it knows
nothing about User Account Control (UAC). This means that after you have
run Access 2007 and you start A2003, it tries to update a whole lot of
important registry settings but fails to do so. To fix it, you must run
Access 2003 "as Administrator" the first time after A2007 has been running.

See here for more info and workarounds:
http://www.allenbrowne.com/bug-17.html.
 
sorry - using winxp. when attempting to open a database, access 2003 and 2007
kept crashing; perhaps this has caused my issue with the reference?

Can i just remove 12.0 objects and add 11.0?

thanks for the help.

Graham Mandeno said:
Hi Patti

Yes, this is a known problem.

Access 2003 was released before Vista was conceived, and therefore it knows
nothing about User Account Control (UAC). This means that after you have
run Access 2007 and you start A2003, it tries to update a whole lot of
important registry settings but fails to do so. To fix it, you must run
Access 2003 "as Administrator" the first time after A2007 has been running.

See here for more info and workarounds:
http://www.allenbrowne.com/bug-17.html.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

patti said:
i have started getting error:
"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."

Access 2007 was recently put on my pc in addition to access 2003.
My references list Microsoft Access 12.0 Objects. Should this be version
11.0?
If so, do i need to delete 12.0 to add 11.0?

i am just learning about VBA references - because i started having
problems
with a database. issues always lead to insight for me.

thanks.
Click to expand...
Click to expand...
 
Hi Patti

Try doing a Help > Detect and Repair on Access 2003.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

patti said:
sorry - using winxp. when attempting to open a database, access 2003 and
2007
kept crashing; perhaps this has caused my issue with the reference?

Can i just remove 12.0 objects and add 11.0?

thanks for the help.

Graham Mandeno said:
Hi Patti

Yes, this is a known problem.

Access 2003 was released before Vista was conceived, and therefore it
knows
nothing about User Account Control (UAC). This means that after you have
run Access 2007 and you start A2003, it tries to update a whole lot of
important registry settings but fails to do so. To fix it, you must run
Access 2003 "as Administrator" the first time after A2007 has been
running.

See here for more info and workarounds:
http://www.allenbrowne.com/bug-17.html.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

patti said:
i have started getting error:
"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."

Access 2007 was recently put on my pc in addition to access 2003.
My references list Microsoft Access 12.0 Objects. Should this be
version
11.0?
If so, do i need to delete 12.0 to add 11.0?

i am just learning about VBA references - because i started having
problems
with a database. issues always lead to insight for me.

thanks.
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the help and support. i opened the db from another pc, checked
that my report would run and closed access. then i was able to open db on my
pc and run reports. don't know if that was the trick but i am back in the
game.

i will be researching references to better understand how they are "carried"
by access and the database itslef.

patti

Graham Mandeno said:
Hi Patti

Try doing a Help > Detect and Repair on Access 2003.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

patti said:
sorry - using winxp. when attempting to open a database, access 2003 and
2007
kept crashing; perhaps this has caused my issue with the reference?

Can i just remove 12.0 objects and add 11.0?

thanks for the help.

Graham Mandeno said:
Hi Patti

Yes, this is a known problem.

Access 2003 was released before Vista was conceived, and therefore it
knows
nothing about User Account Control (UAC). This means that after you have
run Access 2007 and you start A2003, it tries to update a whole lot of
important registry settings but fails to do so. To fix it, you must run
Access 2003 "as Administrator" the first time after A2007 has been
running.

See here for more info and workarounds:
http://www.allenbrowne.com/bug-17.html.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

i have started getting error:
"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."

Access 2007 was recently put on my pc in addition to access 2003.
My references list Microsoft Access 12.0 Objects. Should this be
version
11.0?
If so, do i need to delete 12.0 to add 11.0?

i am just learning about VBA references - because i started having
problems
with a database. issues always lead to insight for me.

thanks.
Click to expand...
Click to expand...
Click to expand...
 
I've got the same problem with a lot of user in my firm.
When they do a detect and repair, the problem is solved, but as they reopen
access 2007, the problem with access 2003 come again, so they have to do a
detect and repair each time...

Is there a way to fixe the problem definitely?
All the users are running in winxp and have access 2003 and 2007. The users
who don't have access 2007 have no problem
 
When you switch from one version to another, the program you are starting
detects that it is not the "current" version, so it goes about fixing things
up. Many of these "fixes" involve making changes to system-wide settings in
the registry. It is likely that your users, unless they are members of an
Administrators group, do not have write permissions to the required registry
keys.

Does this sound like a feasible explanation? If so, then post back and
we'll explore ways of working around it.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

belote said:
I've got the same problem with a lot of user in my firm.
When they do a detect and repair, the problem is solved, but as they
reopen
access 2007, the problem with access 2003 come again, so they have to do a
detect and repair each time...

Is there a way to fixe the problem definitely?
All the users are running in winxp and have access 2003 and 2007. The
users
who don't have access 2007 have no problem

Graham Mandeno said:
Hi Patti

Try doing a Help > Detect and Repair on Access 2003.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand
Click to expand...
Click to expand...
 
Back
Top