Microsoft KB Archive/936748

= 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

Article Last Modified on 8/6/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003

-



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.



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.



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 &quot;More information&quot; 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.



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

Keywords: kbtshoot kbprb kbexpertiseinter KB936748

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.