Help: ActiveX component can't create

[Matthew Gibbons]

My installation of Microsoft Access 2003 (from Microsoft Office 2003
Professional) has stopped working correctly. When I try to create a new
project from new data, I get a dialog box with the message 'ActiveX
component can't create'. I have tried the 'Detect and repair' command from
the help menu, but that fails with the message 'Installation terminated
prematurely'. I have tried to re-install from setup, but with the same
problem. I have tried uninstalling and re-installing both Access and the
complete Office suite, but am left with the same problem.

I work with Microsoft SQL Server 2000, and so know that this was working
previously. I have searched the KB and found a number of articles for a
similar problem with Microsoft Office 2000, all related to problems with
ODBC (which makes sense, since I am experiencing the problem with Access
connecting to the SQL server). I have followed the steps in the KBs, with no
positve results.

Can anyone help?

Regards,
Matthew

 

[Arvin Meyer]

This can also sometimes happen when your references aren't registered
correctly, particularly the DAO reference. Try the following.

1. Locate the DAO reference on your machine which should be at:

C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll

register it:

Start ... Run then type:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"

on 1 line, exactly as you see it above. You should get a message back that
the registration succeeded. Now check your references from any code window
(Tools menu item) make sure that DAO is not marked MISSING. Try everything
again.

HTH,
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Matthew Gibbons]

Thank you for your help - this has sorted the problem out. I actually
remember now having to do a similar thing for ole32.dll when Word
stopped working as the email editor for Outlook...

Thanks again!

Cheers,
Matthew