兴国资源网 Design By www.nnzcdc.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.nnzcdc.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
兴国资源网 Design By www.nnzcdc.com
暂无评论...
更新日志
2024年05月08日
2024年05月08日
- 原神:技术又升级啦?新增角色动作与神态,期待全方面普及
- 林俊杰.2020-幸存者(EP)【华纳】【WAV+CUE】
- 方志耀.1992-给我一点你的爱【飞碟】【WAV+CUE】
- 华晨宇.2015-异类【天娱传媒】【WAV+CUE】
- 月爱解说 王者荣耀一套带走爆发小狐狸妲己攻略
- 吴宇深《时光》[320K/MP3][61.94MB]
- 吴宇深《时光》[FLAC/分轨][86.52MB]
- 张宇《好男人的情歌 精选16首最爱发烧情歌》[WAV+CUE][600MB]
- 原神虹色大巡回第一关攻略 音符补缺打法位置分享
- 王者荣耀五五朋友星活动玩法介绍 规则一览
- 少年西游记2今日全平台公测 真国潮真轻松真福利
- 崩坏星穹铁道2.2光锥怎么抽 崩铁2.2光锥抽取建议
- 崩坏星穹铁道2.2无边曼舞光锥怎么样 崩铁新四星光锥无边曼舞强度
- 崩坏星穹铁道2.2夜色流光溢彩强度介绍 夜色流光溢彩光锥介绍
- 苹果安装双系统好不好,苹果装双系统好用吗