Hi! I currently have a table filled with a list of files, which is being written to by a form. I want to reset the table(delete the data), and the primary key, but I want to keep my table structure ( I have a few fields which are specific, eg. autonumber, memo, date). How can I remove all the data, reset the autonumber, yet keep the table structure? Thanks!!

go into the table, select all the data and hit delete. then go to tools> compact and repair database. this will reset your autonumber

Is there VBA code to do that? Thanks!!