You cannot run the Visual Basic for Applications code in your Microsoft Access 2000 run-time application if you removed Microsoft Office Access 2003 (827490)


The information in this article applies to:

  • Microsoft Office Access 2003
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

For a Microsoft Access 2002 version of this article, see 282336.

SYMPTOMS

You remove Microsoft Office Access 2003, including an Access 2003 run-time application. When you start a Microsoft Access 2000 run-time application, you cannot run the Visual Basic for Applications (VBA) code in your run-time application. You may also receive the following error message:
The expression On<event> you entered as the event property setting produced the following error: There was a problem referencing a property or method of the object.

* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
Note In this error message, event is a placeholder for the name of the event.

CAUSE

When you remove Access 2003, you unregister the Access.Application object in the Microsoft Windows registry. As a result, any VBA code in Access does not function.

RESOLUTION

To resolve this problem, reinstall the Microsoft Access 2000 run-time application. To do this, follow these steps.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, point to Settings, and then click Control Panel.
  2. In the Control Panel window, double-click Add/Remove Programs.
  3. In the Add/Remove Programs dialog box, click Microsoft Access 2000 Runtime in the list of currently installed programs. Click Change.
  4. In the Microsoft Access 2000 Maintenance Mode dialog box, click Repair Microsoft Access 2000 Runtime.
  5. In the Reinstall/Repair Microsoft Access 2000 Runtime dialog box, click Reinstall Access Runtime.

    Note The Repair errors in my Access Runtime installation option does not correct this problem.
  6. Click Finish.
  7. If you are prompted to restart your computer, click Yes.

    The Access 2000 run-time application runs successfully.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Access 2000.
  2. Open the Northwind.mdb sample database.
  3. On the Tools menu, click Startup.
  4. In the Startup dialog box, click to select Main Switchboard in the Display Form/Page list.
  5. Click OK to close the Startup dialog box.
  6. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  7. Start the Package and Deployment Wizard.

    For additional information about how to start the Package and Deployment Wizard, click the following article number to view the article in the Microsoft Knowledge Base:

    236143 MOD2000: How to Start the Package and Deployment Wizard

  8. Create an installation package.

    Use the defaults on each page of the Wizard.

    Note Make sure that the Include Access Runtime check box is selected so that the Access 2000 run-time application is included in the package.
  9. On a computer that does not have Access installed, install the Northwind run-time application.
  10. Start the Northwind run-time application, and then verify that it works.
  11. Close the Northwind run-time application.
  12. Install Access 2003, and then verify that it works.
  13. Verify that the Access 2000 Northwind run-time application works.
  14. Remove Access 2003.
  15. Start the Access 2000 Northwind run-time application.
  16. Click a button on the Main Switchboard form to open another form.

    You receive the error message that is mentioned in the "Symptoms" section.
Modification Type:MinorLast Reviewed:6/3/2004
Keywords:KbVBA kbPDWizard kbPackage kberrmsg kbprb KB827490 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.