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