How to register or unregister an ActiveX control in Access 2007

INTRODUCTION

This article describes how to register or unregister ActiveX controls in Microsoft Office Access 2007.

More information

In earlier versions of Access than Access 2007, you can register or undo ActiveX controls by clicking on the Tools menu. Access 2007, this method is not available in. If you want to register or undo an ActiveX control, use one of the following methods. Method 1: Use the VisualBasic code to register or undo the ActiveX control using the VisualBasic code, run the code directly in the Immediate window, or create the containing code module.

To run VisualBasic code directly in the Immediate window follow these steps:

1.	Access 2007, open the Trust database in, or enable macros in the database.
2.	Press Ctrl+g to open the Immediate window.
3.	Type the following code, and then press Enter. DoCmd.RunCommand Accmdregisteractivexcontrols

To create a code that contains VisualBasic, follow these steps:

1.	Access 2007, open the Trust database in, or enable macros in the database.
2.	Other groups, create a tab in the, and then click the macro on the module.
3.	Create a subroutine that contains the following VisualBasic code. DoCmd.RunCommand Accmdregisteractivexcontrols
4.	Press the F 5 key to run the code.

Method 2: Use the RunCommand macro action

1.	Access 2007, open the Trust database in, or enable macros in the database.
2.	Other groups, create tabs in, and macro by macro.
3.	On the Design tab, click Show/Hide groups to show all the actions.
4.	Action column in the command list, RunCommand in, and registeractivexcontrols in sequence.
5.	Click A0 > Save.
6.	In the tool group, click Run.