Locking down the structure of a database

[steven.butler]

Dear All,

is there any way to look-down the structure of tables within a database so users cannot change tables?

Is it possible to make this password protected so only certain users have rights to change the layout of the tables?

Would this still allow users to create queries and enter data?

Thanks, Steve

 

[neileg]

Full Access security may be what you need. You can lock your whole design by creating an MDE, but this wouldn't allow users to create queries from scratch.