Go to Google Groups Home    microsoft.public.access
RE: ActiveX Objects

Tatakau <tata...@discussions.microsoft.com>

I tend to jump to extreme and unnecessary solutions... but if it's working
fine on other machines, why not re-install office?  If that doesn't work, try
creating a new user on the machine and running the app from there.

Nick

"Garry" wrote:
> I have a database in Access 2000 (using DAO & OS is Windows 2000) that has
> been working fine for several months.  The last time I used it was Dec 29,
> 2005.  I just opened it this morning (jan 22, 2006) and am having major
> problems.  When I try to open certain forms or reports, I get a run time
> error -:
>     Run Time Error '429'  ActiveX component can't create object.
> If I select debug, the debugger highlights VBA instructions for recordsets.  
> Some examples are:
>         set recClone = Me.RecordsetClone
>         set db = Currentdb
>         If Me.RecordsetClone.RecordCount = 0 Then

>   Something seems to have happened to the Office installation since If I
> copy the database to another computer, all is fine.
>   Between Dec 29th and today I have installed the following software:
>          PowerDVD
>          Adobe Reader 7
>          Nero 6
>          ADS DVD Express (analog video/audio capture device - USB) drivers
> and software

>    Also, I have updated the firmware on my DVD burner.  It appears that
> somehow one of the Access or Office components was 'corrupted' by one of
> these updates.
>    Any ideas? Or should I try Uninstalling & reinstalling Office 2000 & the
> updates?

>        Thanks  --  Garry Gross