21 July 2011

ActiveX component can't create object - Error

Cause 1: DAO is not properly registered

Resolution

  1. On the computer that hosts Microsoft Windows Terminal Server or the computer on which Microsoft Access is installed, click Start, and then click Run.
  2. Type regsvr32 followed by the path to your DAO file. Enclose this path in quotation marks. For example, to register the DAO 3.6 library, use the following command:
    regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

Cause 2: One or more references are missing

Resolution

  1. Open the database for which you receive the error message.
  2. Press ALT+F11 to open the Microsoft Visual Basic Editor.
  3. In the Visual Basic Editor, click References on the Tools menu.
  4. Examine the list of libraries. If any items are marked as "missing," locate the library file and re-associate the reference. Or, click to clear the check box next to the library name.

Cause 3: There is a utility database reference that is not valid

Resolution

  1. Open the database for which you receive the error message.
  2. Press ALT+F11 to open the Visual Basic Editor.
  3. In the Visual Basic Editor, click References on the Tools menu.
  4. Click to clear the check box next to any reference to Utility Database or Utility.mda

No comments: