I have an adodc control on a form and all my textboxes are bound to this adodc.
Then when I insert a new record to my Table, I used the coding as follows: adodc1.recordset.update

The problem is that it inserts the record at the end of my table in my access database but in adodc recordset it is not at the end.
why this and what's the solution.

thanks