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.

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


View products that this article applies to.

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 (http://support.microsoft.com/kb/282336/ ) .
For a Microsoft Access 2002 version of this article, see 282336 (http://support.microsoft.com/kb/282336/ ) .

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Status

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

↑ Back to the top


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.

↑ Back to the top


Keywords: KB827490, kbprb, kberrmsg, kbpackage, kbpdwizard, kbvba

↑ Back to the top

Article Info
Article ID : 827490
Revision : 4
Created on : 6/3/2004
Published on : 6/3/2004
Exists online : False
Views : 345