最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
加密你的Access数据库
时间:2022-07-02 21:19:42 编辑:袖梨 来源:一聚教程网
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
相关文章
- 斗罗大陆猎魂世界武魂融合技如何发动 07-08
- 必须拿住:迈克尔·赛勒发布比特币牛市图表 07-08
- 大侠立志传爱猫失踪任务完成指南 07-08
- DOTA2电竞世界杯2025赛程一览 07-08
- YellowPencil Pro v7.6.7 WordPress 可视化 CSS 编辑插件 07-08
- 魔兽世界强力巨魔之血药水怎么获得-强力巨魔之血药水获取方法 07-08