手机
当前位置:查字典教程网 >编程开发 >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数据库移植到SQL Server

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

Access数据库创建宏组

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

Access2007创建数据库图文步骤

基于Access数据库的抽奖系统设计

删除Access数据库中的空记录

搭建小型access数据库实录

两个解决十万条Access数据表分页的方法

加密你的Access数据库

精品推荐
分类导航