MySQL Insert Problem

hi there!

I have a problem adding recorsd to a mysql table.
I use ado connection to the database and when I try to add a record it works really fine but it puts the record on the first position in the table...so... if a try to add another record...it says it already has another record to that position and cannot add it.
Also I tried Insert command but....error in sql statement.

Pleae help me.....first I would like to know if there's any chance for me to add records to database using ado connection and I would like also to have the insert statement for vb6.0.
thanks a lot

There shouldn't be a problem, so it seems like there is something wrong with your code - we'll need to see it to be able to tell what.

There are examples of adding records (using recordsets, Insert statements, etc) in our Database FAQ's at the top of this forum.