• 售前

  • 售后

热门帖子
入门百科

加密你的Access数据库asp打开方法

[复制链接]
我是的十八簿 显示全部楼层 发表于 2021-8-14 14:51:12 |阅读模式 打印 上一主题 下一主题
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

帖子地址: 

回复

使用道具 举报

分享
推广
火星云矿 | 预约S19Pro,享500抵1000!
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

草根技术分享(草根吧)是全球知名中文IT技术交流平台,创建于2021年,包含原创博客、精品问答、职业培训、技术社区、资源下载等产品服务,提供原创、优质、完整内容的专业IT技术开发社区。
  • 官方手机版

  • 微信公众号

  • 商务合作