Runtime Error 429 Access 2003/Windows 2000
Posted on 2007-03-22
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
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....