Ms访问MAC地址指导 [英] Ms access MAC address Guidance

问题描述

我的数据库应用程序设置在F：驱动器，

所以我想设置安全功能，知道是有些正文复制我的数据库并粘贴到另一台PC，所以复制我的数据库的人不是在另一台PC运行它可能与否或访问VBA我已经为我的PC设置了MAC地址所以任何人复制并粘贴另一台PC数据库不运行所以任何解决方案在访问VBA我设置mac地址到我的应用程序数据库..

My Database Application set on F: drive,
so i want to set security feature to know about is that some body copy my database and paste to another PC so those who copy my database is not run in another PC its possible or not or in access VBA i had set MAC address for my PC so anyone copy and paste another PC the database not run so any solution in access VBA that i set mac Address to my application database..

推荐答案

MS Access数据库只是一个文件，可以移动到任何目的地。无法保护它无法移动/复制到VBA级别的其他文件夹。您可以通过执行以下操作来保护此文件免于打开/编辑...

保护Microsoft Access数据库的10个技巧 [ ^ ]

如何帮助保护Microsoft Access数据库的说明 [ ^ ]



就个人而言，当我成为MS Access数据库开发人员时，我一直在做以上大部分建议另外还有一个客户端 - 服务器模型。怎么样？



客户要求：

- 通过自定义身份验证表单担保，

- 没有表格（甚至是链接的）表），

- 所有表格，宏等等，

- 服务器数据库的路径保存在自定义属性 [ ^ ]。



服务器要求：

- 所有表格，查询

- 用密码担保



用户打开客户端数据库，必须通过传递登录名和密码进行身份验证。客户端从自定义属性读取连接字符串并按需连接所需的表...

MS Access databse is just a file, which can be moved to any destination. There is no way to protect it from moving/copying to another folder on the VBA level. You can secure this file from opening/editing by doing several things...
10 tips for securing a Microsoft Access database[^]
Description of how to help protect a Microsoft Access database [^]

Personally, when i've been a MS Access database developer, i've been doing most of above recommendations and additionally a client - server model. How?

Client requirements:
- secured by custom authentication form,
- no tables (even linked tables),
- all forms, macros, etc.,
- path to the server database is saved in custom property[^].

Server requirements:
- all tables, queries
- secured by password

User opens a client database and must authenticate by passing login and password. Client reads connection string from custom property and connects required tables on demand...

这篇关于Ms访问MAC地址指导的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！