[RESOLVED] loop problem using adodb , acess ASAP

[jackob247]

What do you mean by loop problem? There is no loop in the code shown.

Your code needs to use a where clause in the select so you only get the matching record. As coded if there are any records in the DB then it will update the first record every time and never add a second record.

On another note rs248 is an odd name for a recordset. Please tell me that you are not using 248 different recordsets.

Could u tell what kind of where clause that would be helpful.

I am 1st time doing vb project so new to this.

And rs248 was a random pick.