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

See whether reregistering DAO360.dll using regsvr32.exe helps.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Garry" <(E-Mail Removed)> wrote in message
news:F4D91F06-4024-410C-B542-(E-Mail Removed)...
>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
>

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
>

Now I'm really worried. I tried your suggestion and got the message:
"Load Library "DAO360.dll' failed. The specified module could not be
found!"

However, the file DAO360.dll does exist in :
C:\Program Files\Common Files\Microsoft Shared\DAO

I wonder if the registery is messed up?
Garry Gross

"Douglas J. Steele" wrote:

> See whether reregistering DAO360.dll using regsvr32.exe helps.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Garry" <(E-Mail Removed)> wrote in message
> news:F4D91F06-4024-410C-B542-(E-Mail Removed)...
> >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
> >
>
>
>

I think I've got it working now. In the VBE environment under references,
I unselected DAO 3.6. Then reopened Access and tried to reselect it and it
did not appear in the window!.
I then tried the browse function & selected the actual dll file, it
appeared "checked" and all seems to be working fine.
I have absolutely no idea what could have happened.

Thanks for the lead -- Garry Gross

"Douglas J. Steele" wrote:

> See whether reregistering DAO360.dll using regsvr32.exe helps.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Garry" <(E-Mail Removed)> wrote in message
> news:F4D91F06-4024-410C-B542-(E-Mail Removed)...
> >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
> >
>
>
>

Hi Garry,

You got the Load Library error because you used a path that includes spaces
without using quotes around the entire path. For example, the statement shown
in this KB article is wrong, and will produce the same Load Library error on
any Windows PC:

http://support.microsoft.com/?id=833220 See Method 1, section 2, which
includes the following:

Regsvr32.exe C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll

To fix this, you need to either use double quotes, like this:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

or, use the short path form, like this:

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Garry" wrote:

Now I'm really worried. I tried your suggestion and got the message:
"Load Library "DAO360.dll' failed. The specified module could not be
found!"

However, the file DAO360.dll does exist in :
C:\Program Files\Common Files\Microsoft Shared\DAO

I wonder if the registery is messed up?
Garry Gross

Sorry, Tom, but I have to disagree with you. The error message wouldn't have
been "Load Library 'DAO360.dll' failed" if that were the case: regsvr32.exe
wouldn't have realized that DAO360.dll was involved, as it would have
stopped looking after C:\Program. (You would have got "Load Library
'C:\Program' failed")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
news:F1EDA242-7166-42B3-BD5D-(E-Mail Removed)...
> Hi Garry,
>
> You got the Load Library error because you used a path that includes
spaces
> without using quotes around the entire path. For example, the statement
shown
> in this KB article is wrong, and will produce the same Load Library error
on
> any Windows PC:
>
> http://support.microsoft.com/?id=833220 See Method 1, section 2, which
> includes the following:
>
> Regsvr32.exe C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll
>
> To fix this, you need to either use double quotes, like this:
>
> Regsvr32.exe "C:\Program Files\Common Files\Microsoft
Shared\DAO\Dao360.dll"
>
> or, use the short path form, like this:
>
> Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
> "Garry" wrote:
>
> Now I'm really worried. I tried your suggestion and got the message:
> "Load Library "DAO360.dll' failed. The specified module could not be
> found!"
>
> However, the file DAO360.dll does exist in :
> C:\Program Files\Common Files\Microsoft Shared\DAO
>
> I wonder if the registery is messed up?
> Garry Gross
>
>

Hi Doug,

You're absolutely right. I keyed in on the Load Library error, which I've
received myself when using the directions currently shown in the KB article,
without paying attention to the difference in the results: 'C:\Program
failed' versus 'DAO360.dll failed'.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Douglas J Steele" wrote:

Sorry, Tom, but I have to disagree with you. The error message wouldn't have
been "Load Library 'DAO360.dll' failed" if that were the case: regsvr32.exe
wouldn't have realized that DAO360.dll was involved, as it would have
stopped looking after C:\Program. (You would have got "Load Library
'C:\Program' failed")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

I had the same issue where the 429 error message appeared when I loaded a
program. I followed instructions for loading DAO360 but that did not seem to
be the issue as it was sitting where it was supposed to be.

I copied in the command as: regsvr32 "C:\Program Files\Common
Files\MicrosoftShared\DAO\dao360.dll"\dao\dao360.dll" with and without
quotes.
Neither worked. And I cut and pasted and also typed in the command.

Then I tried the: Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
and it successfully registered...

And my program works...

Go Figure.

Best to all.

Jeremy

(E-Mail Removed)



"Tatakau" wrote:

> 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
> >

The original path you were using was wrong. It should have been

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

and that should have worked. (You were missing a space in Microsoft Shared,
and you had that extra bit at the end)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Arinborn" <(E-Mail Removed)> wrote in message
news:9D065CAF-CB8B-4F13-A93E-(E-Mail Removed)...
> I had the same issue where the 429 error message appeared when I loaded a
> program. I followed instructions for loading DAO360 but that did not seem
to
> be the issue as it was sitting where it was supposed to be.
>
> I copied in the command as: regsvr32 "C:\Program Files\Common
> Files\MicrosoftShared\DAO\dao360.dll"\dao\dao360.dll" with and without
> quotes.
> Neither worked. And I cut and pasted and also typed in the command.
>
> Then I tried the: Regsvr32.exe
C:\progra~1\common~1\micros~1\dao\dao360.dll
> and it successfully registered...
>
> And my program works...
>
> Go Figure.
>
> Best to all.
>
> Jeremy
>
> (E-Mail Removed)
>
>
>
> "Tatakau" wrote:
>
> > 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
> > >