手机
当前位置:查字典教程网 >编程开发 >Access数据库 >加密你的Access数据库asp打开方法
加密你的Access数据库asp打开方法
摘要:SecureYourAccessDatabaseHowcanyoukeepunwantedpeoplefromdownloadingyour...

SecureYourAccessDatabase

Howcanyoukeepunwantedpeoplefromdownloadingyourdatabasesimplybytypingintheurl?

Youcan't,itisnotpossible.BUTyoucansecureitbyaddingapasswordtoit.BelowIwill

walkyouthroughthestepsneededtoaccomplishthis.

1.Downloadyourdatabase(newfeatureaddedtoday,seeabove).

2.OpenitupinMSAccess.(Checkthe"Exclusive"checkboxinthefiledialogbox.Ifyoudon't,

Accesswillaskyoutolater.)

3.MenuBar-->Tools-->Security-->SetDatabasePasswordSelect"Tools"fromthemenubar,

then"Security",then"SetDatabasePassword."

4.Yourpasswordcanbe:(quotedfromMSAccessHelp)"Passwordscanbeanycombinationof14or

fewercharacters,exceptcontrolcharacters.Passwordsarecase-sensitive."

5.UploadyourpasswordprotecteddatabasetoBrinkster.

6.Whatneedstobechangedinyourcode:

Onlyyourconnectionstringneedstobechanged.Hereisasample:

SetConn=Server.CreateObject("ADODB.Connection")

MyConnStr="DRIVER={MicrosoftAccessDriver(*.mdb)};"

MyConnStr=MyConnStr&"DBQ=d:sitesmembernamedbmydbase.mdb;"

MyConnStr=MyConnStr&"PWD=yourpassword"

Conn.Open(MyConnStr)

Addthe"PWD=yourpassword"totheconnectionstringandyouareset!

7.IntheSQLMgr,anewfieldhasbeenaddedforpassword.ThiswayyoucanstillusetheSQL

Mgr,evenifyourAccessdatabasehasbeenpasswordprotected!

By:JaredStauffer

【加密你的Access数据库asp打开方法】相关文章:

access数据库密码找回方法详解

Access数据库累计余额的计算方法

用C#动态创建Access数据库

长期使用中型Access数据库的一点经验与缺点

Access数据库如何压缩与修复

如何在Access中创建数据表

Access2007创建数据库图文步骤

实现Access数据库的Web查询

access爆数据库系统路径方法

了解Access数据库的4种安全方式

精品推荐
分类导航