Prevent users from seeing design view of a form

[Kapay]

Can someone help me from preventing users from seeing design views of forms.

 

[Hayley Baxter]

You can either implement user level security and don't give the users permissions to view the design of your form or if you don't want to bother with that you can go to Tools menu, startup and disable the menus from here and display your switchboard form on open. This way your user cannot get into any of the design - unless they know about the shift bypass key but this can be removed also.

 

[Neilw]

if you go to the tools menu and click startup it will take you to a dialogue box where you can uncheck the tool bars. This will prevent anyone from being able to get into the design view. From here you can also set it not to show the database window which you will also need to do. Make sure you also set a form to open on startup though!

 

[s.booth]

You could possibly convert the database file from a *.mdb to a *.mde file this will restrict what people can see behind the scenes. There is a tool in Tools/Database Utilities to do this. Hope this helps.

 

[Neilw]

out of interest hayley, what is the shift bypass key?

 

[Hayley Baxter]

Holding down the shift key allows anyone to access the design of your database despite disabling all the menus if they are aware of this.

 

[Jonathan Kok]

Shhh....it's a secret!