Microsoft KB Archive/827490

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

Article ID: 827490

Article Last Modified on 6/3/2004

-

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 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,  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.
 * 1) Click Finish.
 * 2) 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 &quot;Applies to&quot; section.



Steps to Reproduce the Behavior
 Start Access 2000. Open the Northwind.mdb sample database. On the Tools menu, click Startup. In the Startup dialog box, click to select Main Switchboard in the Display Form/Page list. Click OK to close the Startup dialog box.</li> On the Tools menu, point to Macro, and then click Visual Basic Editor.</li> 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

</li> 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.</li> On a computer that does not have Access installed, install the Northwind run-time application.</li> Start the Northwind run-time application, and then verify that it works.</li> Close the Northwind run-time application.</li> Install Access 2003, and then verify that it works.</li> Verify that the Access 2000 Northwind run-time application works.</li> Remove Access 2003.</li> Start the Access 2000 Northwind run-time application.</li> Click a button on the Main Switchboard form to open another form.

You receive the error message that is mentioned in the &quot;Symptoms&quot; section.</li></ol>

Additional query words: acc2003

Keywords: kberrmsg kbpdwizard kbpackage kbprb kbvba KB827490

-

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

© Microsoft Corporation. All rights reserved.