I am having issues with items randomly getting deleted in our SQL server database. I have checked the codes in front end (access) and unable to locate the cause of the items getting deleted. Is there away I can write something in the SQL server management studio side that before an item is deleted it actually backs up that row in the table to another location?
This way if I wanted to retrieve any missing data I would be able to just copy them from one location to another.
Thanks in advance.