Disabling Tables & Queries

[Baghzaad]

Hi,

Can anyone tell me how to disable the "Design" , "Delete" and the "New"
option from the "Tables" & "Queries". I have created a MDE but it does not
disable the above 3 options.

Thanks.

 

[Rick Brandt]

Hi,

Can anyone tell me how to disable the "Design" , "Delete" and the "New"
option from the "Tables" & "Queries". I have created a MDE but it does not
disable the above 3 options.

Correct, only code-based objects are locked in an MDE (forms, reports, modules).
To prevent changes to queries and tables you need to implement full-blown user
level security. A fairly advanced topic that nearly everyone gets wrong on the
first attempt. Google this group for "Security FAQ" and you will get plenty of
links to sources you should study thoroughly before attempting this (on a copy
of your database).