Lightwave
Ad astra
- Local time
- Today, 03:05
- Joined
- Sep 27, 2004
- Messages
- 1,537
Just thought I'd note to people a potential hazard that they may come across if they install both Access 2003 and Access 2007 on a single machine.
Many of you will be familiar with the reinstall / de-install process that the operating system does when you move between versions of Office be that between Excel / word or other office versions. This feature specifically relates when users have both Access 07 and Access 03 on the same machine.
When you open Microsoft Access 2007, it changes the following registry key to point to the Access 12 Object Library:
[HKEY_USERS\S-1-5-21-680354291-1286354565-1361462980-1003\Software\Classes\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@="C:\\Program Files\\Microsoft Office\\Office12\\MSACC.OLB"
When you open Access 03 the installer should change this key back to Office 11.
[HKEY_USERS\S-1-5-21-680354291-1286354565-1361462980-1003\Software\Classes\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@="C:\\Program Files\\Microsoft Office\\Office11\\MSACC.OLB"
Unfortunately at some point this can stop working and the installer will NOT set the key back to the correct value (leaves it pointing to Office 12) If you then try to open any Access 2003 form you end up with the error.
"Object or Class does not support the set of events"
To solve the problem you have to manually point the registry key back to the Office 11 version of the file.
Microsoft’s official response on this issue is to create a .reg file with the correct version of the key, and manually run it before opening Access 2003 after you’ve been in Access 2007.
Initially I thought this was just a feature of Vista but I'm getting it on a XP machine as well. Possible that an update from MS inctroduced this to the operating system.
Many of you will be familiar with the reinstall / de-install process that the operating system does when you move between versions of Office be that between Excel / word or other office versions. This feature specifically relates when users have both Access 07 and Access 03 on the same machine.
When you open Microsoft Access 2007, it changes the following registry key to point to the Access 12 Object Library:
[HKEY_USERS\S-1-5-21-680354291-1286354565-1361462980-1003\Software\Classes\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@="C:\\Program Files\\Microsoft Office\\Office12\\MSACC.OLB"
When you open Access 03 the installer should change this key back to Office 11.
[HKEY_USERS\S-1-5-21-680354291-1286354565-1361462980-1003\Software\Classes\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@="C:\\Program Files\\Microsoft Office\\Office11\\MSACC.OLB"
Unfortunately at some point this can stop working and the installer will NOT set the key back to the correct value (leaves it pointing to Office 12) If you then try to open any Access 2003 form you end up with the error.
"Object or Class does not support the set of events"
To solve the problem you have to manually point the registry key back to the Office 11 version of the file.
Microsoft’s official response on this issue is to create a .reg file with the correct version of the key, and manually run it before opening Access 2003 after you’ve been in Access 2007.
Initially I thought this was just a feature of Vista but I'm getting it on a XP machine as well. Possible that an update from MS inctroduced this to the operating system.
Last edited:
