如何锁定设计视图? [英] How to lock Design View?
问题描述
我如何在Microsoft Access数据库中锁定表单等的设计视图，以使授予我该权限的人无法编辑项目?
您可以通过以下方式锁定Access表单:设计"视图不再可见，并且数据表"视图等也不再可见. /p>
锁定数据库也有好处，它可以撬开眼睛来编译(例如加密)任何VBA ...有用！
首先，您需要确定是只锁定 设计视图，还是所有其他视图.如果您只想锁定 设计视图，请直接跳到步骤6.
如果您的项目与Access的早期版本不向后兼容，则对MDB文件的任何引用都将显示为ACCDB文件.任何对MDE文件的引用都将显示为ACCDE.
1..如果您的项目另存为与Access 97/2000兼容，则必须首先将其转换为2002格式.您可以通过以下方法来执行此操作:转到Orb>另存为> Access 2002-2003数据库:
2..打开任何表格
3.打开设计视图"
4..从打开的默认选项卡(表单设计工具">设计")中，选择属性表":
5..从属性表中，将要锁定的视图更改为否":
6..最后，要创建锁定的数据库文件，请选择数据库工具">制作MDE":
7..系统将询问您要将新的MDE文件保存到的位置.您的旧MDB文件将被保留.
重要说明: :保留旧的MDB文件！如果您需要对项目进行任何更改，则只能在原始MDB文件中进行 操作.
How can I lock the Design View of forms etc in a Microsoft Access database so that the person I give this to cannot edit the project?
You can lock your Access forms down in such a way that the Design View is no longer visible, and optionally the Datasheet View etc are also no longer visible.
Locking your database also has the bonus that it compiles (e.g. encrypts) any VBA from prying eyes... useful!
First you need to decide whether you want to lock only Design View, or also all other Views. If you want to lock only Design View, then skip right ahead to Step 6.
If your project is not backwards-compatible to previous versions of Access, then any references to MDB files will show for you as ACCDB files. Any reference to MDE files will show for you as ACCDE.
1. If your project is saved as Access 97/2000 compatible, you must first convert it to 2002 format. You can do this by going to the Orb > Save As > Access 2002-2003 Database:
2. Open any form
3. Open Design View
4. From the default tab that opens (Form Design Tools > Design), select Property Sheet:
5. From the Property Sheet, change the Views that you want to lock to No:
6. Finally, to create your locked down database file, select Database Tools > Make MDE:
7. You will be asked where you want to save the new MDE file to. Your old MDB file will be retained.
IMPORTANT NOTE: Keep your old MDB file!! If you ever need to make any changes to your project, you can only do this in the original MDB file.
这篇关于如何锁定设计视图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
