加密你的Access数据库

devjoy.cn技术文档
　　Secure Your Access Database

    How can you keep unwanted people from downloading your database simply by typing in the url?

You can't, it is not possible. BUT you can secure it by adding a password to it. Below I will

walk you through the steps needed to accomplish this.

1. Download your database (new feature added today, see above).快乐开发技术文档
一起娱乐网01716.com
2. Open it up in MS Access. (Check the "Exclusive" checkbox in the file dialog box. If you don't,

Access will ask you to later.)devjoy.cn技术文档

3. Menu Bar --> Tools --> Security --> Set Database Password Select "Tools" from the menu bar,

一起娱乐网01716.com

then "Security", then "Set Database Password."

4. Your password can be: (quoted from MS Access Help) "Passwords can be any combination of 14 or

javascript技巧尽在快乐开发

fewer characters, except control characters. Passwords are case-sensitive."

5. Upload your password protected database to Brinkster.

一起娱乐网01716.com

6. What needs to be changed in your code:
Only your connection string needs to be changed. Here is a sample:

Set Conn = Server.CreateObject("ADODB.Connection")
MyConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; "
MyConnStr = MyConnStr & "DBQ=d:\sites\membername\db\mydbase.mdb; "
MyConnStr = MyConnStr & "PWD=yourpassword"
Conn.Open(MyConnStr)

Add the "PWD=yourpassword" to the connection string and you are set!

7. In the SQL Mgr, a new field has been added for password. This way you can still use the SQL

Mgr, even if your Access database has been password protected!

javascript技巧尽在快乐开发

By: Jared Stauffer