加密你的Access数据库asp打开方法_Access数据库教程-查字典教程网
加密你的Access数据库asp打开方法
加密你的Access数据库asp打开方法
发布时间:2016-12-29 来源:查字典编辑
摘要: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数据库学习
    热门Access数据库学习
    编程开发子分类