prevention of edit forms/tables

hi

how do i prevent user from entering into the 'design view', 'datasheet view' of my form??? how can i prevent them for entering to the database window (where you can choose to create table in design view or wizard.)??

pls advice
nono

Tools, startup

Each of those properties gives you different ability to control what the user can or can't do. Research them more in the help before getting to carried away, becuase you can lock you self out also if you are not careful (be sure to give yourself a backdoor)

S-

hi,

i have try the startup but i still can see my database windows when i click on the open menu. is there other ways that it will really disallow user to view the database window??


pls advice
nono

The startup properties will do everything you are asking. I have a database where nothing, but a customerized menu is visible and there is no way in, except where I have a password driven form, that allows me to change the startup properties with VB so that the next time I open the database I can gain the access I need by holding the shift key down.

Trust me this is where it is at look in help on each of the property options in the startup (start with "display database window").

S-

however everthing works well but it still allow me to make changes to my form as when i right-click the form, i can still see the design view.

how can i prevent this to happen???? how can i make sure that the user cannot make changes to the form???


pls advice
nono

Allow default shortcut menus

S-

what are the SHORTCUTS to amend the changes???

nono

Turn off the option "Allow default shortcut menus" in the startup properties.

s-

yuppie!!!

that is great but i knew that we actually can somehow using shift keys to open the database with a password.....

how can i do that??

pls advice
nono

cheers
nono

I don't beleive that it is possible to put a password on the shift action.

What I usually do is disable everything (including the shift action) and create a form, who's access is password protected, that allows me to remove startup protection properties and restore them.

This way I can totally block out the users (including myself), unless absolutely neccesary. When you remove startup protection properites, they don't take affect untill the next time the Db is loaded.

S-

See attached DB for form

Forgot to tell, Do this in test enviroment first.

S-