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

    Accepted Solution

    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


    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 65

    Expert Comment

    by:Jim Horn
    >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

    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    Value of 0's not appearing. 9 40
    moving data between msaccess and sql server. 3 30
    Wrong number of arguments 2 15
    Show Balance 3 15
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now