加密你的Access數據庫asp打開方法_Access數據庫教程
教程Tag:暫無Tag,歡迎添加,賺取U幣!
推薦:access下如何恢復已經刪除的記錄;如何恢復已經刪除的表、窗體等等對象access下如何恢復已經刪除的記錄;如何恢復已經刪除的表、窗體等等對象
Secure Your Access DatabaseHow 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).
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.)
3. Menu Bar --> Tools --> Security --> Set Database Password Select "Tools" from the menu bar,
then "Security", then "Set Database Password."
4. Your password can be: (quoted from MS Access Help) "Passwords can be any combination of 14 or
fewer characters, except control characters. Passwords are case-sensitive."
5. Upload your password protected database to Brinkster.
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:sitesmembernamedbmydbase.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!
By: Jared Stauffer
分享:恢復從 Access 2000、 Access 2002 或 Access 2003 中數據庫刪除表的方法恢復從 Access 2000、 Access 2002 或 Access 2003 中數據庫刪除表的方法
相關Access數據庫教程:
- 相關鏈接:
- 教程說明:
Access數據庫教程-加密你的Access數據庫asp打開方法
。