快活林资源网 Design By www.csstdc.com
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
快活林资源网 Design By www.csstdc.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
快活林资源网 Design By www.csstdc.com
暂无评论...
更新日志
2024年05月08日
2024年05月08日
- dnf2小时武动之魂教程
- 你喜欢奔驰还是美女的大腿?动图看鬼片中的初音未来
- 《星刃》:丑化角色不是写实归宿,韩式ARPG的华丽典范
- 《庄园领主》:RE:从零开始的赛博领主生活
- [ABC]群星《模拟声音AnalogSound[6N纯银镀膜]》[正版原抓WAV+CUE]
- ABC唱片-《托尼班内特.我可爱的情人》6N纯银镀膜[WAV+CUE]
- ABC唱片-《帕尔曼.帕尔曼的声音》6N纯银镀膜[WAV+CUE]
- 真·跨作品比战力:《范马刃牙VS拳愿阿修罗》正式预告公开!
- 官方视频意外泄密?《星空》资料片或聚焦瓦鲁恩家族
- 恐怖片既视感!女子称坐张家界末班缆车差点被吓晕
- 老虎鱼《森海塞尔 HD 800耳机试音碟》2CD[DFF][1.4G]
- 降央卓玛《鸿雁BSCD》[WAV+CUE][457M]
- 群星《Burn in CD-煲机王》[WAV+CUE][430M]
- 原画壁纸及美图第213期,无水印可自取
- 原画壁纸及美图第214期,无水印可自取