Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
You may receive error messages when you use wizards and VBA commands in Access 2003 on a Windows-Vista based computer that has Access 2007 and Access 2003 installed
| Article ID | : | 936748 |
| Last Review | : | August 6, 2007 |
| Revision | : | 2.0 |
On This Page
SYMPTOMS
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.
Back to the top
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
Back to the top
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
Back to the top
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.
Back to the top
CAUSE
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.
Back to the top
WORKAROUND
To work around this problem, use one of the following methods.
Back to the top
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.
Back to the top
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
Back to the top
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.
Back to the top
MORE INFORMATION
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
Back to the top
APPLIES TO
| • | Microsoft Office Access 2007 |
| • | Microsoft Office Access 2003 |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please