如何防止最终用户在 MS Access 2010 应用程序中从前端查看后端数据？
我有一个 Access 应用程序，它分为存储数据表的后端和驻留 UI 和业务逻辑的前端。我如何在不允许最终用户通过前端查看后端数据表的情况下分发应用程序。 我将前端编译为 .accde 文件并禁用“显示导航窗格”和“使用访问特殊键”选项。此外，我有一个 VBA 代码，执行该代码以在退出时禁用这些选项，这样如果最终用户启用它们，它们就会被代码禁用。但是，如果用户启用这些选项，然后从任务管理器中终止 MS Access，则当再次启动前端时，用户可以查看导航窗格。
保护我的应用程序以便用户只能访问表单和报告而不能访问基础数据的最佳方法是什么？
I have an Access Application that is split into a back-end where the data tables are stored, and a front-end where the UI and business logic resides. I what to distribute the application without allowing the end-user to view the data tables in the back-end through the front-end.
I compile the front-end into an .accde file and disable "Display Navigation Pane" and the "Use Access Special Keys" options. Further, I have a VBA code that executes to disable these options on exit so that if the end-user enables them, then they get disabled by the code. However, if the user enables the options then kills MS Access from the task manager, then when the front-end is launched again, the user can view the Navigation Pane.
What is the best way to protect my application so that the user can only access forms and reports and not the underlying data?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
不知道这是否是您正在寻找的答案，但您可能会考虑将数据迁移到 MSDE/SQL Server Express。它们为表和查询提供用户级安全性。
Do not know whether this might be the answer you are looking for but you might consider migrating your data to MSDE/SQL Server Express. They offer user-level security on tables and queries.
如果您禁用用于打开数据库的 Shift 键，则用户应该无法更改您的设置。请注意，通过这种方式可能会将您自己锁定在数据库之外。
另请参阅：MS Access 启动属性
如果保护数据至关重要，你可能需要看看Access以外的数据库，有了Access，你可以防止意外篡改，但真正恶意的篡改就会得逞。
If you disable the shift-key for opening the database, the user should not be able to change your settings. Note that it is possible to lock you yourself out of the db this way.
See also: MS Access Start up Properties
If proctecting your data is critical, you may need t look at a database other than Access, with Access, you can protect from accidental tampering, but really malicious tampering will get through.