Database lock

[CosmaL]

Hello my friends,


I've got a request for a database but i would like to lock the file so when the user will work he will not have access to tables/forms/code/design etc.


An experienced user could use shift to unlock/unhide the tables/routines/forms etc.


Do you suggest any way to totally lock the environment so he could only use the available forms?
I would like to have access in the file just in case there's is a need to modify/back up something.


Thank you in advance!!!!!


Best Regards,
Costas

 

[isladogs]

Suggest you hide the navigation pane and ribbon and distribute as an ACCDE file so the code isn't accessible. However you need to ensure that all required functionality is available from forms
As the developer you would work in the ACCDB version.

 

[The_Doc_Man]

You can hide things for a while but if you have anything that someone wants, they WILL break into it. Search this forum for the topic of "Securing a Database" to see many articles on the subject.

 

[CosmaL]

Thank you all!


I'll try to keep the objects and menus as hidden as i can!