 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
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! 返回类别: 教程 上一教程: 让使用者可以看到你的ASP的原代码 下一教程: 在SQL SERVER中保存和输出图片 您可以阅读与"加密你的ACCESS数据库"相关的教程: · 使用ASP加密算法加密你的数据（一） · 如何使用 MICROSOFT ACCESS 和 ACTIVE SERVER PAGES 加密你的页面 · 使用ASP加密算法加密你的数据 · 使用ASP加密算法加密你的数据(一) · 如何使用MICROSOFT ACCESS和ACTIVE SERVER PAGES加密你的页面 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
