When classified is running with MS Access database (or SQL database frequently backed up with Conversion Tools to MS Access file), then it is strongly recommended to prevent downloading of the db/cldb.mdb database file by site visitors. Some web hosting providers incorporate various solutions to forbid access to .mdb files from browser. To test, you could try to download database in a browser:
http://www.your_site.com/db/cldb.mdb
If you receive a message: Access denied or forbidden, then MS Access database secure.
Moving MS Access database off the site rootNevertheless, regardless of an outcome of the test above, it is recommended to move database under the site root. In other words, move "db" folder to the location unreachable from a browser. Some providers allow that and some do not. For example: you open your site in FTP and see a folder [httpdocs]. Your site root (all web pages) located inside that folder (name of the folder could be different from httpdocs). If you are able to create a new folder or upload files to the same level as [httpdocs], then those files and folders pretty much secure and cannot be accessed from web browser.
Move "db" folder to the same level as [httpdocs]. Since location of "db" folder changed, you need to change configuration files and point to the new database location. Do the following:
Open config/config.asp configuration file in text editor and amend [dbFolder] variable, which points to the "db" folder location.
By default the line looks like: dbFolder = "db/"
Change it to: dbFolder = "../db/"
[../"] in the reference above tells to look for the folder below the site root. It also called parent folder.
Note: Some providers disallow to reference parent folders in this way. In which case, this method of extra protection is not applicable.
Renaming "db" folder or placing "db" folder into special App_Data folderThe other method is renaming "db" folder. This method provides the least protection however. Rename "db" folder and change the value for [dbFolder] variable in config/config.asp configuration file.
Example: dbFolder = "new_db_folder_name/"
Alternatively you may place the "db" folder into special App_Data folder. With functional ASP.NET at the site, this folder is not accessible from web browser at all. After moving "db" folder, make respective changes in config/config.asp configuration file:
dbFolder = "Apps_Data/db/"
When classified is running with MS Access database (or SQL database frequently backed up with Conversion Tools to MS Access file), then it is strongly recommended to prevent downloading of the db/cldb.mdb database file by site visitors. Some web hosting providers incorporate various solutions to forbid access to .mdb files from browser. To test, you could try to download database in a browser: