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

编辑Tag赚U币
教程Tag:暂无Tag,欢迎添加,赚取U币!

推荐: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)

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

分享:恢复从 Access 2000、 Access 2002 或 Access 2003 中数据库删除表的方法
恢复从 Access 2000、 Access 2002 或 Access 2003 中数据库删除表的方法

来源:模板无忧//所属分类:Access数据库教程/更新时间:2013-04-22
相关Access数据库教程