<:#240,4560><+!><:f200,BHelvetica,0,0,0>Benefits of Password Protection<-!><:f>
@Normal@<:#1920,4560>The password features of Approach 2.0 protect data and/or database design from alteration by non-authorized users. Protect all of the information in a database file by setting Read/Write and Read Only passwords for the database via the Database Options cho
ice under the File menu. Protect the design of your database by setting a view password via the Save As menu.
@Normal@<:#231,4560><:f200,BHelvetica,0,0,0>
@Normal@<:#240,4560><+!><:f200,BHelvetica,0,0,0>Read/Write Password for Database Files<-!><:f>
@Normal@<:#2160,4560>Setting a Read/Write Password allows entry into a database and associated view file only with the correct password. If an incorrect password is entered, Approach displays the message "STOP Cannot open the database <<<<filename<;><;> because you didn't give
a valid password." The password protection is also active if you try to open the database directly or through another view file. <[>Note: you MUST set a read/write password BEFORE setting a read only password.]
@Normal@<:#240,4560>
@Normal@<:#240,4560>To Set a Read/Write Password
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>1. In Design mode select Database Options from the File menu.
@step@<:#720,4560><:f200,6Times New Roman,0,0,0>2. Within the Database Options Dialog select the name of the database you want to set the read/write password for.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>3. Select Set Read/Write Password, enter the password in the text box, and select OK.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>4. Retype the password in the Confirm Password dialog and select OK.
@Normal@<:#480,4560>If there are joined databases repeat the steps for all databases you want Read/Write Password protected.
@Normal@<:#240,4560>
@Normal@<:#240,4560><+!><:f200,BHelvetica,0,0,0>Read Only Password for Database Files<-!><:f>
@Normal@<:#720,4560>A Read Only Password allows you to view but not edit a database file's field data. This feature is only available AFTER a Read/Write Password is set for a file.
@Normal@<:#240,4560>
@Normal@<:#480,4560>To Set a Read Only Password (After setting the Read/Write Password)
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>1. Again, in Design mode, select Database Options from the File Menu.
@step@<:#720,4560><:f200,6Times New Roman,0,0,0>2. Within the Database Options dialog select the name of the database you want to set the Read Only password for.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>3. Select Set Read Only Password, enter the password in the text box and select OK.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>4. Retype the password in the Confirm Password dialog and select OK.
@Normal@<:#480,4560>If there are joined databases repeat the steps for all databases you want Read Only Password protected.
@Normal@<:#240,4560>
@Normal@<:#720,4560>Once both Read/Write and Read Only Passwords are set the access level of each user is controlled by which password is entered in the Enter Password dialog.
@Normal@<:#240,4560>
@Normal@<:#1680,4560>One variation might be to create a Read/Write Password for authorized users and a BLANK Read Only Password for others. With this setup users without a password can simply click OK at the Enter Password dialog to gain Read Only access to the file. Those wh
o know the password can enter it at the Enter Password dialog for full Read/Write access.
@Normal@<:#240,4560>
@Normal@<:#240,4560><+!><:f200,BHelvetica,0,0,0>Read Only Fields for a View File
@Normal@<:#1680,4560><+!><-!>This option is set in the Database Options dialog, like the database passwords mentioned above. But, it applies only to the view file and not the underlying database file. Another view file accessing the same database will have full access. Also,
users aren't prompted for a password when opening a View file that has this option.
@Normal@<:#240,4560>
@Normal@<:#240,4560>To Set Read Only Fields for a View File:
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>1. In Design mode select Database Options from the File menu.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>2. Within the Database Options dialog select the option Read Only Fields for View File.
@step@<:#240,4560><:f200,6Times New Roman,0,0,0>3. Save the View file.
@Normal@<:#480,4560>Once the View is closed and reopened all of the fields will be Read Only.
@Normal@<:#240,4560>
@Normal@<:#240,4560><+!><:f200,BHelvetica,0,0,0>Read Only Fields for a Specific Form or Report<-!><:f>
@Normal@<:#720,4560>Setting a database field to Read Only for a specific form or report in a View file allows users to view but not edit the data in that field.
@Normal@<:#240,4560>
@Normal@<:#240,4560>To Set a Field to Read Only:
@step@<:#240,4560><:f200,6Times New Roman,0,0,0>1. In Design mode select the field.
@step@<:#720,4560><:f200,6Times New Roman,0,0,0>2. Open the Field Style dialog by selecting it from under the Style Menu or by double clicking on the selected field.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>3. Within the Field Style dialog select the Read Only option.
@Normal@<:#240,4560>
@Normal@<:#1200,4560>This Read Only setting is specific to that field on that form or report. If you set a field on Form 1 to Read Only and the same field is displayed on Form 2, the field won't be Read Only on Form 2 unless you also set the Read Only option for the field on F
orm 2.
@Normal@<:#240,4560>
@Normal@<:#240,4560><+!><:f200,BHelvetica,0,0,0>Password Protection for View File Design<-!><:f>
@Normal@<:#960,4560>Setting a View file password prevents alteration of the design of a View file. Field data can be read or written but the design of forms, reports, etc., can't be altered without the correct password.
@Normal@<:#240,4560>
@Normal@<:#240,4560>To set a View File Password:
@Normal@<:#240,4560>1. Select Save As from the File menu.
@step@<:#720,4560><:f200,6Times New Roman,0,0,0>2. Select Set View Password and enter the password in the text box. Also, select the radio button for Same Data. Click OK.
@step@<:#1680,4560><:f200,6Times New Roman,0,0,0>3. A message (referring to the view file) will appear: "This File already exists. Replace existing file?" Select Yes to keep the same View file name and overwrite the original View file. Select No and enter a different Vie
w file name to create a new View file. Either way, the saved View file will have the View password.
@step@<:#480,4560><:f200,6Times New Roman,0,0,0>5. Retype the password at the Confirm Password dialog and click okay.
@step@<:#960,4560><:f200,6Times New Roman,0,0,0>6. Select Short Menus to limit menu and toolbar access for those who do not know the password. Not selecting this option gives users full Browse mode access.
@step@<:#1200,4560><:f200,6Times New Roman,0,0,0>7. Approach displays the Enter View Password dialog whenever an attempt is made to enter Design mode while in a passworded View. Without the proper password the user cannot enter Design mode and make changes to the design of
the View file.
@Normal@<:#240,4560>
@Normal@<:#1440,4560>The View file password can be removed through the same procedure by leaving the Set View Password option unselected. Or, if you want to change between short and full menus for a password protected View file, again use this procedure selecting the desired m