Tell me, is it possible to create some restrictions on the tables without creating forms?

For example, that users could view the table, but could not edit.

Is it possible to put a limit on the list of columns?

    2 answers 2

    The MS Access security system is implemented at a rudimentary level and is very easy to manage. Previously (Access 97-2003) used the following hack:

    • Tables that need to be hidden are placed in a separate database;
    • In this separate database, in the "Startup Parameters" dialog, daws are reset to show the database window and enable standard shortcut keys ;
    • The DB is put on a network drive;
    • In the main database, queries are made to hidden tables with the necessary filters. Queries are written to return non-modifiable data sets.

    Do not forget backups

      The restriction on the tables can be put through the workgroup file. Previously, he had the extension mdw. Accordingly, access has a GUI for editing this file.