When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?
Printable View
When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?
Have a look at AddNew, but in your case, I would advise that you don't need to put it in a specific order in the table. Just re-order it when you SELECT the records.
I'll bet you don't have a primary key defined...Quote:
Originally posted by mikki
When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?
My primary is ClientID