First of all, the differences in security functions between access2007 and earlier versions of access.
If you have used Access,
The experience of security features in earlier versions is that you have to make a series of choices. For example, you must choose a security level (low, medium, or high), and you must also choose whether to run potentially unsafe code. When you are at
Access 2007
You don't have to worry about how to make such a decision when you open the database. By default, access2007 disables all potentially unsafe code or other components, regardless of whether they were used when the database was created.
Which version of Access?
Second, use the database password to encrypt the Office access2007 database.
office
The encryption tool in access2007 combines the previous two tools: database password and coding, and improves on this basis. After using the database password to encrypt the database, not only can other tools not read all the data in it, but users must also enter the password to use the database. and
Compared with earlier versions of Access, the encryption algorithm applied in access2007 is more advanced.
Third, package, sign and distribute the access2007 database.
With access2007, you can sign and distribute the database more conveniently and quickly. When it was created. Accdb file or. accde。
After creating a file, you can package the file, then apply a digital signature to the package, and then distribute the signed package to other users. The packaging and signing features put the database in an Access deployment.
(.accdc) file, and after signing the package, put the package that passed through code signing in your determined location.
Fourth, the new security features in access2007:
1. The ability to view data, even if you don't want to enable any disabled VBA code or components in the database. In Office Access 2003.
If the security level is set to high, you must code signing and trust the database before you can view the data. In the office,
In access2007, you can open the database and view the data at any time without deciding whether the contents of the database should be enabled.
2. The usability is significantly enhanced. If the database file (whether to use the new Office)
Access2007 file format or earlier file format) is placed in a trusted location (for example, a folder or network that you designated as a safe location * * *). When these files are opened and run, no warning message will be displayed, and no prohibited content will be enabled. In addition, if you open it in access2007.
Databases created in earlier versions of Access (such as. Mdb or. mde)
Files), and these databases have been digitally signed, and you have chosen to trust the publisher, you do not need to make a trust decision to run these files. But remember, VBA is in the signed database.
The code will run only if you trust the publisher, and it will not run when the digital signature is invalid. If someone other than the signer tampers with the contents of the database, the signature will be invalid.
3. Trust Center. The Trust Center is a dialog box for setting and changing security settings so that access can provide a location. Create or change trusted locations and set up Office.
Access2007 security option, you can use the Trust Center. These settings affect how new and existing databases are accessed and how they behave when opened in this instance. The Trust Center also contains the logic to calculate the components in the database, determine whether the Trust Center should disable the database, and let you decide whether to enable it when you turn on database security.
Access 2007 download: Web link