after i had delete the records by the following line: objConnection.execute "DELETE * FROM tea_session_list" what should i add to the statement to have the autonumber id also being resetted to be start at 1. i dun wan to do it by compacting database...can i do it in a new script with the delete statement....what should i add to my above statement???

after i had delete the records by the following line: objConnection.execute "DELETE * FROM tea_session_list" what should i add to the statement to have the autonumber id also being resetted to be start at 1 aaa

how to reset the autonumber id when deleting records in a table......meaning how to have the id starting at 1 again

"&objRecordset("buffet")&" this is one of the sentence for my programme. there r four choices in the recordset. wat should i add in the programme,so as the item which the customer had chosen will be inserted into the database???As there's another script after this,the inserting of data will be carry out in the next script.:) :) :)

how to update the last data. objConnection.Execute "UPDATE buffet_list SET buffet = 2500 WHERE order_id=???" wat should i put in place of the ??? to get the last order_id??? order_id is Autonumber aaa

as there r different types of food in my menu.In order to display it in the browser wat the customer had ordered,i need to program it in the sense that it was sent to their respective columns.For example,when he chose steak,steak was inserted into the field "steak".how m i going to make the program to insert the food into their respective field???