Protect Forms V MDE

[Oldsoftboss]

Is there a way to disable design mode of your forms without making an MDE file. Trying to steer away from an MDE as I would still like to be able to alter report layouts based on different situations.

Dave

 

[Rich]

Access "security" ? Best of luck

 

[DBL]

You can change the setup options to hide the menus, toolbars and shortcut opetions, except from any custom ones you have and you can also hide the database window. This way, unless they know what they are doing you can stop the users from getting in to the background. If you think that they might know that holding down the Shift key as the database opens disables the startup menus, you can disable the Shift key and also create a hidden backdoor that only you know how to get in to! Search the forum for instructions. It's not fool proof but it's a start until you're ready to make your MDE

 

[Oldsoftboss]

Thanks DBL
Have done all of the above - hidden database window, made my own menus, disabled the F11 & the shift key - with success.

It was more of a question could it be done as I thought I had seen it done on a microsoft example somewhere, solutions or northwind or somewhere but cant remember where exactly.
Will keep looking and keep you posted.

 

[Rich]

You can of course permanently hide all the objects in a distributed db, but keep a back up for yourself

 

[ghudson]

FYI

If you compact a db that has hidden objects...

They will be deleted!

As Rich stated, make and keep current backups!

 

[Rich]

Only if you use code to hide them in newer versions I believe, I've never lost any in 97