You have a Windows Vista-based computer that has Microsoft Office Access 2007 and Microsoft Office Access 2003 installed. In this case, you encounter one of the following symptoms.
Symptom 1
After you run Access 2007, you may receive the following error messages when you use wizards and Microsoft Visual Basic for Applications (VBA) commands in Access 2003:
Error message 1
Variable uses an Automation type not supported in Visual Basic
Error message2
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
Symptom 2
When you use the Form Wizard in Access 2003, a blank form may open, and you may receive the following error message:
The wizard is unable to create your form
Symptom 3
When you edit the existing code in the Microsoft Visual Basic window in Access 2003, Access 2003 stops responding. Additionally, you receive the following error message:
Microsoft Office Access has Stopped Working.
These problems occur because of the user account control (UAC) feature in Windows Vista. When you open a database in Access 2003, UAC stops Access 2003 from updating references to the Microsoft Access 11.0 libraries.
To work around this problem, use one of the following methods.
Method 1
Keep only one version of Access on the computer. To do this, you must uninstall Access 2007 or Access 2003. For more information about this method, see the "More information" section.
Method 2
Run the Msaccess.exe file by using the
Run As Administrator option.
For more information about how to run the file by using this option, click the following article number to view the article in the Microsoft Knowledge Base:
922708
(http://kbalertz.com/Feedback.aspx?kbNumber=922708/
)
How to use User Account Control (UAC) in Windows Vista
Method 3
Delete the Msacc.olb file for Access 2003. Then, repair the Access 2003 installation.
Note When you restart Access 2007, you experience this problem again. To work around this problem, you must use this method again.
We do not recommend that you install multiple versions of Microsoft Office on a single computer. However, you can install and use multiple versions of Microsoft Office on a single computer. For example, you can install and use both the Microsoft 2007 Office suite and Microsoft Office 2003 on a single computer.
Note Microsoft does not support using multiple versions of Microsoft Office on versions of Microsoft Windows that have Terminal Services enabled. If you want to run multiple versions of Office, disable Terminal Services.
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
928091
(http://kbalertz.com/Feedback.aspx?kbNumber=928091/
)
Information about using 2007 Office suites and programs on a computer that is running another version of Office
870961
(http://kbalertz.com/Feedback.aspx?kbNumber=870961/
)
Description of how to run multiple versions of Microsoft Access with Access 2003
Article ID: 936748 - Last Review: August 6, 2007 - Revision: 2.1
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office Access 2003
| kbtshoot kbexpertiseinter kbprb KB936748 |