Access数据库加密的方法
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
rpassword” 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 好了，Access 数据库加密内容就给大家介绍到这里了。希望大家学业有 成，工作顺利
Access 数据库加密的方法
欢迎大家在这里学习 Access 数据库加密!这里是我们给大家整理出来的 精彩内容。我相信，这些问题也肯定是很多朋友在关心的，所以我就给大家 谈谈这个! 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)
Access 数据库加密的方法
欢迎大家在这里学习 Access 数据库加密!这里是我们给大家整理出来的 精彩内容。我相信，这些问题也肯定是很多朋友在关心的，所以我就给大家 谈谈这个! 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)