Password for DB

[Vugar]

Hi everyone,

Can I create a rule no one could see the tables, queries except me.

Thank you

 

[arnelgp]

you can always hide the navigation pane.

 

[Vugar]

I know, but they can unhide it too.

 

[arnelgp]

Create a macro named Autokeys, while on design create a submacro. name the submacro {F11}. on "add new action" select Beep. save your macro

now on File->Options->Current Database, untick Display Navigation Panes.

quit access and open your database. users will not see Navigation Pane nor can they open it using shortcutkey F11.

 

[Vugar]

I'm new on macro. thank you.

I can't do it

 

[Uncle Gizmo]

There are many online resources to help you learn how to create macros. I suggest you search the Internet and have a look at some.

If you have problems finding such resources then post back, I'm sure someone will find some links for you.

 

[arnelgp]

of course you can, here is an example of Autokeys macro. just click on the macro, then copy and paste to your db.

 

[gemma-the-husky]

that's a neat trick, arnelgp

of course it keeps the developer out of it as well!

 

[arnelgp]

not entirely, use the backdoor shift-key while the db is loading.

 

[Vugar]

Could you please tell how I can do it (backdoor shift-key)

 

[arnelgp]

while holding the shift-key double-click your db to open (or if it is already selected, press enter while holding the shift-key).