password protect query in Ms access 2003

[as7685]

hello folks.,
i need to password protect query in ms access 2003 so that users cannot access the queries ?
please tell me how to set that options in ms access 2003..
thank you.

 

[Tigs81]

One way might be to remove the database window.

Open Access
Goto Tools, Startup
Untick Display Database window.

to open with Database window
Hold down shift on startup

 

[Mike375]

Another simplt way is to rename the queries so each new name starts with

USys

So you would rename query1 as USysquery1

On Tools>Options>View you can hide system objects and that will mean you can'y see any query with the name having USys at the start

You will find the default is System Objects will be unticked for Show