first of all, i using ADO control to connect database. the problem is
instead of adding new record, they overwrite the current record..So how izit actually to add a new record?

this is the code i use to add a new record

DataSchedule2.Recordset.UpdateBatch adAffectCurrent
DataSchedule2.Recordset.AddNew

help plz