I really didn't expect this.If you cannot trust the user to not manipulate the data against company rules, then why give them permission at all.
Before I answer that, let me ask you something. As a database developer, you create a FE, with strict rules, with a lot of codes in beforeupdate to restrict input data, hide the tables, use accde instead of accdb and a hundred more other steps to be sure the input data is correct. Why? If you don't trust your user, why do you allow him accessing the database.
It's not a matter of trust. It's a matter of you, as a developer, need the data being manipulated as you want. Not as the user want.
In a new order registration form, the Date field is locked and its default value is set to Now().
Why? because you don't want the user (by mistake) input a date earlier than today.
But if this user can access the tables via HIS database, he may do this mistake. And you can do nothing to prevent him.
Can you see where I'm going?