Numerous Ways to Protect Your MDB File

Microsoft Access database file is designed to be used by the MS Access program or other program such as ASP. Your Mdb file can only be protected by employing features and methods understood by these programs. Otherwise anything done to the MDB file outside these methods would make the file unreadable.

Many people upload their MDB files to the same folder as their ASP files. Then they think about it a bit, and assume they need to create a DSN to put the MDB file outside of the web folder and refer to it with a local path. This is certainly one way to prevent people from downloading your Access database, but it is not likely the best. For one, a DSN is less efficient, and you can use a non-web path in a DSN-less connection string. Next, you're going to have a hard time updating your database structure if you need physical access to the local file system in order to see the file at all.

One more method is use of FTP’s folders, but if you think FTP is any more secure than making someone guess the location and filename, you're wrong. Unless you name your database "database.mdb", I doubt very much that anyone would be able to find it. If you name your database file some odd name like FHQWHS.mdb, then it's probably pretty safe from anything.

You might have imagined that those would be all of your options, but I think the best is naming your database file something like FHQWHG.asp. This way, even if someone were to guess the location, if they typed it in the browser and tried to download it, they'd get nothing but garbage since IIS will try to process it as an ASP file. The Access interface itself has no issues saving or opening an MDB file with any other extension.

But still in some case due to saving MDB file in this form cause corruption in database file and high loss of database loss and corruption. In this situation compact and repair utility also doesn’t help to us. Now we need some recovery or access repair softwares. Access repair software repairs all the forms, queries, macros, modules, reports and data types which have been used by the user while developing its database.

Stellar Phoenix access recovery utility is best tool for repair and recovery of database or mdb files. It is one of those access repair software that provides the most excellent options comparatively. This Access Repair software works well with all the file versions of Access counting Access 97, 2000, 2002/ XP, 2003 and 2007. This software can also repair the fields and the images included.