Question Database Lock down

[Core]

Hello,

I have created a database for my company. I want to limit the permissions end users will have. I want to lock all design to the database (similuar to make ACCDE) however I want to re-enable design permissions to administrators, this would be done via a button on the form prompting a password.

I know this is possible because I have seen this in databases, however I do not no how to do the same, I can make it ACCDE which is great however as far as I understand I cannot achieve what I want above.

Any help is greatly appreciated.

Regards,

 

[HiTechCoach]

In Access 2007, there in no longer the built-in User Level Security. You will have to create your own.

I want to limit the permissions end users will have. I want to lock all design to the database (similuar to make ACCDE) however I want to re-enable design permissions to administrators, this would be done via a button on the form prompting a password.

If this is a multi user database that is set up properly then it will be split into a front end and back end and each user will have their own copy of the front end. You will have a master accdb when design changes are made. When ready to deploy the changes, hopefully after getting fully tested, a new accde is created and placed on the server so each user can get a new copy.

I do not see how what you are asking for will ever work. How will the administrators be able to open every copy of the front end (normally ion each users machine) to make changes in your described setup?