Runtime Error 429  Access 2003/Windows 2000

Posted on 2007-03-22
Medium Priority
Last Modified: 2013-11-28
Our HR dept uses a database to track certain info on volunteers and contractors.... There is a form that has a drop-down list on it where they can select the employee and go to that record....

Three users have access to this database on separate machines....
On ONE machine the user is getting this error when she clicks a name in the list:

Runtime Error '429'
ActiveX component can't create object

One of the other users got this error some time ago and I remember fixing it by re-registering the file
DAO350.dll in c:\program files\common files\microsoft shared\DAO

But the same fix is not working here...

When you click debug on this error you get the following:

Private Sub cboFind_AfterUpdate()
  '  Find the record that matches the control.
        Dim rs As Object

------>      Set rs = Me.Recordset.Clone    <---------
        rs.FindFirst "[Emp_id] = " & Str(Me![cboFind], 0))
        If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

the part i noted above with the ----> <----- signs is what is highlighted in yellow.

Any help is appreciated.

Also, I did not create this DB and do not know anything about how it was created etc....
Question by:dspent
  • 2
LVL 86
ID: 18774587
If this happens on a previously working machine, then the most likely culprit is the DAO .dll file, but apparently that won't work for you. Try doing a repair of the Office installation on that machine (which basicallyl re-registers all the correct dll, ocx, etc etc files) and see if that clears it up. In my experience, if the DAO reregister doesn't work then youll end up pulling out less hair with a repair than anything else. If the repair doesn't work you may need to re-install Access or MDAC ...

Accepted Solution

dspent earned 0 total points
ID: 18774729
reinstalling office/access/mdac etc.  didn't work...

Anyway. Problem resolved now.
Here's what I had to do...
Open the offending module, go to Tools Resources and then browse to the DAO360.DLL....check the box.

That fixed the issue.  Don't know why or how, but it did.
LVL 86
ID: 18783639
No problem from me ... glad you got is fixed dspent.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question