Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to lock users out of being able to view and edit a form in design mode in Access 2007?

share|improve this question
add comment

2 Answers

One way to approach it is distributing a ACCDE file to users.

  • Database Tools... Make ACCDE
  • Save your Database as an .accde file for distribution.

Here's the description from the Access help files:

An .accde file is the Office Access 2007 version of the .mde file in earlier versions of Access. It is a locked-down version of the original .accdb file. If the .accdb file contained any VBA code, only the compiled code is included in the .accde file — as a result, the VBA code cannot be viewed or modified by the user. Also, .accde file users do not have permissions to make design changes to forms or reports.

This allows you to keep the original ACCDB file, while providing user access to the ACCDE file. Of course, this implies creating a new ACCDE file whenever a change is made to the ACCDB. For this reason, you might want to keep your data in a separate, linked ACCDB database and your forms in the ACCDE. This will allow you to replace the ACCDE files at any moment without losing any data.

share|improve this answer
add comment

Another option is to ONLY allow the users to use the Access Runtime, which disables ALL designing tools. It's free and doesn't require a separate copy of Office Professional or Microsoft Access to run

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.