Run-Time Error 429 on reference Me.Recordset.RecordCount (ActiveX component can't create object or return reference to this object)

Posted on 2005-05-13
Medium Priority
Last Modified: 2012-06-27
I have a database that several individuals are using.  One, and only one of the individuals receives the following error:  Run-time error '429':  ActiveX component can't create object or return reference to this object.

I checked all of the references on the users system, and nothing seems to be missing.  I even installed MDAC 2.8, to no avail.

The line that the error occurs on is as follows.

"If (Me.CurrentRecord > Me.Recordset.RecordCount) Then"

The reference which actually causes the error is "Me.Recordset.RecordCount".

"Me" is a subform, created from an existing form.  The existing form(and this subform) have a record source specified which is a single table. I imagine this could have some impact.

I know that the RecordCount property is available from both DAO and ADO.  As I mentioned I did install MDAC 2.8 and hoped this would resolve any problem with ActiveX components, but I imagine this should have also addressed any problems with DAO?

Any input would be greatly appreciated.  Thanks in advance,

- Michael

Question by:mjs082969
  • 2
  • 2
LVL 66

Accepted Solution

Jim Horn earned 1000 total points
ID: 13996373
If your form is unbound then it would throw this type of error.  Try using this if..then loop around your code

If Nz(Me.RecordSource) = 0 Then
   'Your code goes here
End If

Hope this helps.

Author Comment

ID: 13996679

Should I concern myself with the fact several people don't experience this issue.  Or is this one of those "if you do it wrong, you will eventually get burned situations" and I finally got burned situations.

Thanks for your input/assistance!

- Michael
LVL 66

Expert Comment

by:Jim Horn
ID: 13996708
>several people
Several people very likely have several different pc's, with several different configurations, which means 'some' may not have a file that your app needs.

Author Comment

ID: 14441450
That worked for that instance, but another error of the same type wasn't waiting very far away.

I determined that the issue was probably that my DAO resources had not been properly registered.  After I re-registered DAO360.DLL (in the Run box:  regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL").

After registering the DLL, I no longer experienced the issue.

Thanks Jim!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

809 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