resetting id after deleting records
Database
2
Posts
2
Posters
4
Views
1
Watching
-
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
Compacting the database will solve your problem First, eliminate all records in your table. Then, close the database but leave Access running. The menu bar reduces to three options. Go to Tools > Options > Compact Databases. I am not sure how you would do this at runtime !! :cool: