Tools are also available for decompiling and unlocking but some elements like original VBA formtating and comments are irretrievable. ACCDB 2007 database gets converted to a ACCDE file. Changes made to the VBA project also must be made to the original MDB and reconverted to MDE.

Access MDE VersionĪ database can be protected or locked and source code compiled by converting the DB to an MDE file if a database needs to be locked to prevent unauthorized changes.

Access databases can be encrypted and the Access 2007 ACCDB format provides advanced encryption of older versions. EncryptionĪnother form of protection is encryption. Keep in mind that workgroup security isn’t supported in the ACCDB database Access 2007 format, although 2007 supports workgroup security for MDB databases. A workgroup security file also exists that contains settings used for managing multiple databases. Although very helpful if you want specify data entry or read only rights, this can be a challenge to specify. Groups and individual users can be specified as well as rights at the individual object or object type level. The next level is workgroup security that requires both a user name as well as password. A password is easily cracked and relatively weak protection. The database password is the basic level of seccurity and once it is entered, a user has complete control of the database objects. Open your application as you normally would, holding. In the Open text box, type msaccess /decompile and click Open. MS Access provides the following methods to secure an application while still allowing users to remain active: Go to the Windows Start menu Run command.

Microsoft access mde to mdb decompiler