Security (Restricted Access) For Query Design View

[nizam]

Hi friend,


Does any ones help me to check whether "The Design View" for the Queries is possible to secure.
Means is it possible to give password for viewing the queries in design view ( Not the encrypting database with password).
I need to restrict the queries only..
If any one knows kindly tell me how if it is possible...

[apr pillai]

Different level of Access Rights on Objects can be implemented through Microsoft Access Security, if your version of Microsoft Access is earlier than 2007.

Take a look at the link:Microsoft Access Security and other related links.