手机
当前位置:查字典教程网 >编程开发 >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打开方法】相关文章:

Access3.6 为数据库指定标题

关闭Access数据库默认输入法的方法

Access3.3 定义数据库名称和所在目录

实现Access数据库的Web查询

Access2007创建数据库图文步骤

Access数据库创建宏组

用C#压缩和修复Access数据库

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

搭建小型access数据库实录

access数据库密码查看器怎么用?

精品推荐
分类导航