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
