如何为MS Access数据库分配用户名和密码？ [英] How do I assign a username and password to an MS Access database?

问题描述

如何为MS Access数据库分配用户名和密码？

How do I assign a username and password to an MS Access database?

推荐答案

如果我没错，Access数据库（数据库密码）受到保护使用 SHA-1 [ ^ ]算法。

If i''m not wrong, Access databases (database password) are protected with SHA-1[^] algorithm.

引用：

数据库密码是在MS Access 95时代引入的，是一种易于使用的新安全功能。与设置复杂的用户级安全性相比，设置控制谁可以打开数据库的单个密码既快又容易。如果设置了数据库密码，则所有用户都必须输入该密码才能打开数据库。



数据库密码已加密并存储在数据库文件的标题中。在Access版本95和97中，加密是不安全的，并且标头中的单个字节更改足以删除密码。 ***



如果数据库标头损坏（通常在使用文本编辑器打开和保存数据库时发生，MS Word是一种流行的选择）访问可能会错误报告数据库密码保护而不是损坏。

Database passwords were introduced back in the times of MS Access 95 as a new, easy to use security feature. Setting up a single password that controls who can open a database is both faster and easier compared to setting up a complicated user-level security. If there''s a database password set, all users must enter that password to open the database.

The database password is encrypted and stored in the header of a database file. In Access versions 95 and 97 encryption was insecure and a single byte change in the header was enough to remove the password. ***

If a database header gets corrupted (usually happens when a databases is opened and saved using a text editor, MS Word is a popular choice) Access might erroneously report the database password protected instead of damaged.

src： http：/ /www.vb123.com/toolshed/03_map/accesspasswords.htm [ ^ ]



*** - 要从Ms Access''97数据库中删除密码，请将20B（67 - 86）替换为安全来自不安全数据库的20B数据库。

要从Ms Access 2K中删除密码，请替换40B，但这些40B还可以根据文件创建日期使用密钥进行保护。



这就是我所知道的全部;）





创建，更改或删除密码（MDB） [ ^ ]

如何在MS Access 2007中设置数据库密码？ [ ^ ]

如何创建安全访问数据库？ [ ^ ]

[/ EDIT]

src: http://www.vb123.com/toolshed/03_map/accesspasswords.htm[^]

*** - To remove password from Ms Access ''97 database, replace 20B (67 - 86) in secured database with the 20B from unsecured database.
To remove password from Ms Access 2K, replace 40B, but these 40B are additionally secured with key based on file creation date.

That''s all what i know ;)


Create, change, or remove passwords (MDB)[^]
How to set Database Password in MS Access 2007?[^]
how to create secure access database?[^]
[/EDIT]

这篇关于如何为MS Access数据库分配用户名和密码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！