Create a new table from the main table when user press Enter button

Hi All

I designed an application in Excel as a frontend and Access as a backend. Now my problem is to create a new temp table from the main table each time user press enter so that if sometimes a user makes some mess in the main table then we have the backup present and so we can recover any disaster to main table without doing anything manually.
I want vba code so that when the user press enter button then before making any changes in the main table in Access, make another table and save all the data in it and name it with current date and time. so every time the user press enter a new table should be created first before making any changes in the main table. So in total the 100 temporary tables can be created and when the count of new tables reach 100 then it should delete all of temporay table except the main table. I know we can use the following statement to create a temporary table from the main table:

CREATE TABLE temp AS select * from tblmain

But how to name each new created table with current date and time and how to write a condition that when the count reaches 100 then delete all the temporary tables.

I hope anyone can help me out.

Thanks