Message from discussion ActiveX Objects

Thread-Topic: ActiveX Objects
thread-index: AcYfgZQYSC3oFcE4TX2JK1MX7fqHkA==
X-WBNR-Posting-Host: 64.108.174.86
From: "=?Utf-8?B?VGF0YWthdQ==?=" <Tata...@discussions.microsoft.com>
References:  <F4D91F06-4024-410C-B542-727A4B0F40C1@microsoft.com>
Subject: RE: ActiveX Objects
Date: Sun, 22 Jan 2006 10:28:02 -0800
Lines: 37
Message-ID: <482CA6D7-D3A5-4BCA-B953-4E921134A18C@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.access
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: g2news1.google.com!news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!nntp.infostrada.it!nntp.eutelia.it!feeder.news.tin.it!207.46.248.18.MISMATCH!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl

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
>