It needs to be more difficult to accidentally delete data in the database. I don't know how you do this, but all I know is Access automatically saves changes even when I don't want it to. If I accidentally delete something, it's gone forever.
You are so right!.
Elimination of data that took years to gather and enter should at the very least require explicit intention, decision, and action - not just, "Ooops!"
We humans are flawed. We get tired. We get distracted. We get absorbed in our work. Sometimes we mess up.. Rather than rely on the likes of us to use the right settings day in and day out in query after query, it just seems more efficient for a database to be organized such that it does not revise or eliminate data without specific instruction by a user to do so. (as well as any applicable security checks, of course).
Paradox used to accomplish this by generating a query answer table that was separate and distinct from the initial database(s), so that nothing in the quey and nothing that a user did to the answer table would affect the original data or data structure, UNLESS a user purposely instructed the database to do so. .
I am sure that Access can come up with more elegant, convenient, and idiot-proof solution to this. And speaking for all of us idiots, I really hope that they do. :)