accde should also remove the ablity to modify tables and queries
When one creates an accde database, Ms access 2007 SP3 up to 2016 should also remove the ability to modify tables and queries.

5 comments
-
david savage commented
If an accde is ran from a system that has Access software installed, then ALL tables. queries, reports, and their designs in the databases should be hidden from all view. It would not be a good thing for end-users to see a list of these tables/queries/reports. If they do, then they'll be curious to what they do by double-clicking on them, which could lead to other issues.
-
Scottgem Access MVP since 2007 commented
-
KVD commented
Often wondered what was the point of making an MDE or ACCDE if the end user can see your ER diagram, modify queries, etc. I keep wishing for the type of freezing you see in a commercial package like QuickBooks where you can enter data but may not see the innards at all.
-
Anders Ebro (TheSmileyCoder) commented
While I might argue that it could be nice to OPTIONALLY turn of whether a user can interfere with it, I've done both table and querie modifications "on-the-fly" in access compiled files running code. I would hate to see that ability go away.
-
+1