ActiveX Objects - microsoft.public.access

Message from discussion ActiveX Objects

Tatakau

View profile

More options Jan 23 2006, 5:28 am

Newsgroups: microsoft.public.access

From: "Tatakau" <Tata...@discussions.microsoft.com>

Date: Sun, 22 Jan 2006 10:28:02 -0800

Local: Mon, Jan 23 2006 5:28 am

Subject: RE: ActiveX Objects

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

Reply to author Forward