Is there a way to lock the tables of a file while still keeping forms open to edit that will make changes to the tables only through the forms?
Novice
Windows 8 
Access 2010 32bit
Is there a way to lock the tables of a file while still keeping forms open to edit that will make changes to the tables only through the forms?
Very Inert Person
Windows 7 32bit Access 2007
You can't "lock" them and still make them available for editing by forms (or any other method). It's counter-intuitive.
Maybe what your saying is you want to hide them or keep nosy users out? This is why databases are split, front ends (FE) are compiled and have the bypass key disabled, and (sometimes) tables are linked from the BE to the FE with a password.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Forms and Tables
Posting Permissions
Reply With Quote