Yes. First of all, you should split the database into a Back-end (that
holds all the tables and nothing else) and a Front-end (that holds
everything BUT the tables) and then link the tables from the BE into the FE.
This way they cannot change the table structure or relationships from the
FrontEnd. (They still can in the Back End, but this minimizes the
possibility.)
Next, convert your FE into an MDE. You can do this from Tools > Database
Utilities menu. You don't actually convert your MDB, the wizard makes a new
copy of the FE as an MDE. In this copy, the user cannot change forms,
reports, macros, or modules. AND NEITHER CAN YOU. So it is important to
keep your MDB for making any modifications.
This is not perfect or fool-proof. As I said, they could still change the
tables if they opened the BE. Further, they could delete Linked tables.
And they can also modify any queries stored in the database. However, while
not perfect, it does minimize the chances of tampering.
