加密你的Access数据库asp打开方法
更新时间:2007年07月31日 14:57:36 作者:
(福利推荐:【腾讯云】服务器最新限时优惠活动,云服务器1核2G仅99元/年、2核4G仅768元/3年,立即抢购>>>:9i0i.cn/qcloud)
(福利推荐:你还在原价购买阿里云服务器?现在阿里云0.8折限时抢购活动来啦!4核8G企业云服务器仅2998元/3年,立即抢购>>>:9i0i.cn/aliyun)
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).
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
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).
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
相关文章
union这个连接是有什么用的和INNER JOIN有什么区别
union这个连接是有什么用的和INNER JOIN有什么区别...2006-07-07建立自由的会计日期的报表--1.3.根据用户选择日期自动计算期初期末日期
建立自由的会计日期的报表--1.3.根据用户选择日期自动计算期初期末日期...2006-11-11Access使用宏控制程序--1.5.一个宏的实例——检验口令
Access使用宏控制程序--1.5.一个宏的实例——检验口令...2006-11-11中文Access2000速成教程--1.4 使用“表向导”建立新表
中文Access2000速成教程--1.4 使用“表向导”建立新表...2006-11-11中文Access2000速成教程--1.2 使用“数据库向导”创建表
中文Access2000速成教程--1.2 使用“数据库向导”创建表...2006-11-11
最新评论