Disabling Tables & Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Baghzaad said:
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.
Click to expand...

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).
 
Back
Top