80010108 client disconnected - URGENT

[cturner]

We are having problems with a database created. the error we get is Run-Time error '-2147417848(80010108)':
Method 'FindFirst' of object 'Recordset' failed

We can succesfully enter in one record on a subform but when trying to enter the second we always come up with this error. if we end the error and try it again the record is successful but again the next one we try gives us the error.

We are at a standstill on this database and it has become very urgent to correct. We have looked everywhere for the answer but have found nothing. Hoping someone here has some help.

Thanks,

 

[workmad3]

from what you've said, id recommend making sure that a requery or update has been done on the subform after you have entered the value. Not sure though, as am not the best access programmer around here

 

[cturner]

Thanks

Thanks for the quick reply but...(info from my code person)

The recordset is not touched until the findfirst. While debugging, all methods of the recordset fail (movefirst, edit, requery, addnew). It is possible to get different errors, but they all seem to be the same error with different wording.

 

[workmad3]

in which case, i think this might be applicable

http://support.microsoft.com/default.aspx?scid=kb;en-us;199113

 

[cturner]

...

Although the problem is occurring on a continuous subform, it does not appear that is the cause.

Briefly what happens is: On the subform 1 field is entered, which is the primary key of the subform table. On that control's afterupdate there is extensive code which pulls data from another table and attempts to fill in the rest of the fields related to the field being entered. The code uses an ADODB recordset to pull data from an outside table, but never references the forms recordset. When trying to manipulate the form.recordset is where the error occurs.

The error does not occur on first try, only the second. After that Access crashes and tries to dump to MS.

 

[KeithIT]

Are you referencing an ADO or DAO recordset? DAO recordsets allow for findfirst, ADO do not. Check out the FAQ on ADO and DAO conversion for more info on this.