reference vba 2003 vs 2007

[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.

 

[Graham Mandeno]

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.

 

[patti]

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.

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.

 

[Graham Mandeno]

Hi Patti

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

Graham Mandeno [Access MVP]
Auckland, New Zealand

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.

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.

 

[patti]

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

Hi Patti

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

Graham Mandeno [Access MVP]
Auckland, New Zealand

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.

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.

 

[belote]

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]

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

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

Hi Patti

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

Graham Mandeno [Access MVP]
Auckland, New Zealand