Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

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.

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.

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

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

↑ 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 Information about using 2007 Office suites and programs on a computer that is running another version of Office

870961 Description of how to run multiple versions of Microsoft Access with Access 2003

↑ Back to the top

Keywords: kbtshoot, kbexpertiseinter, kbprb, kb

↑ Back to the top

Article Info
Article ID : 936748
Revision : 1
Created on : 1/7/2017
Published on : 10/30/2008
Exists online : False
Views : 235