Maintaining a Workgroup To encrypt a database
Open the database, and on the Tools menu, point to Security, and then click Encrypt/Decrypt Database.
Navigate to the folder in which you want to store the encrypted file, name the encrypted file you are creating, and click Save.
Encrypting and Decrypting a Database To decrypt a database
With the database closed, on the Tools menu, point to Security, and click Encrypt/Decrypt Database.
In the Encrypt/Decrypt Database dialog box, navigate to the folder that contains the encrypted database, click the encrypted database file, and then click OK.
In the File name box, type a name for the decrypted database, and click Save.
Assigning a Password to a Database To assign a password to a database
On the Database toolbar, click the Open button.
In the Open dialog box, navigate to the folder that contains the database you want to assign a password to, and click the file name.
Click the Open button’s down arrow, and then click Open Exclusive.
On the Tools menu, point to Security, and click Set Database Password.
In the Verify box, type the password again, and then click OK.
Close and reopen the database (you will have to type the password).
Sharing a Database To share a database
Replicating a Database To replicate a database
Right-click the desktop, point to New, and then click Briefcase on the shortcut menu.
Click the Windows Start button, and navigate to the folder that contains the database you want to replicate.
Reduce the size of the window, and position it so that you can see both the database file and briefcase on your desktop.
Drag the database to the briefcase.
Click Yes to continue.
Click Yes to have Briefcase make a backup copy of your database.
Click OK to accept the option to allow design changes only in the original copy of the database and to finish the replication process.
Splitting a Database To split a database
Open the database you want to split, and on the Tools menu, point to Database Utilities, and click Database Splitter.
Click Split Database.
In the Create Back-end Database dialog box, navigate to the folder where you want to store the database components. In the File name box, type the name you want, and then click Split.
Setting Up a Workgroup To create a workgroup
Open the database, and on the Tools menu, point to Security, and then click User-Level Security Wizard.
On the first page of the Security Wizard, click Next to create a new workgroup information file (WIF).
Replace the text in the WID box by selecting it and typing a new workgroup ID.
Accept the default selection to create a shortcut to open the security-enhanced database, and click Next.
Click Next to accept the default selections and secure all objects.
Select the check boxes for Full Data Users and New Data Users, and then click Next.
Click Next.
To add users to the list, in the User name box, type a name of a user, in the Password box, type a password, and then click Add This User to the List.
Click Next.
Click Finish in the wizard’s final page to accept the default name for the backup copy of your unsecured database.
Preventing Changes to a Database To secure the VBA code in a database
On the VBA Editor’s Tools menu, click the Properties command for the database you have open.
In the Project Properties dialog box, click the Protection tab, and click the Lock project for viewing check box.
In the Confirm Password box, type the password again, and then click OK.
Securing a Database for Distribution To convert a database to Access 2002-2003 format
With the database you want to convert closed, on the Tools menu, point to Database Utilities, point to Convert Database, and click To Access 2002 – 2003 File Format.
In the Database to Convert From dialog box, navigate to the folder that contains the database you want to convert, and double-click the file name.
In the File name box, type a name for the converted database, and click Save.
Click OK.
Securing a Database for Distribution To secure a database by saving it as an MDE file
Make sure the database you want to secure as an MDE file is first converted to Access 2002-2003 format.
With the database closed, on the Tools menu, point to Database Utilities, and click Make MDE File.
In the Database To Save As MDE dialog box, navigate to the folder that contains the file you want to save as an MDE file, click the file, and then click Make MDE.
In the File name box, type a name for the file, and then click Save.