Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/Passwords
!AWApr94/Goodies/PowerBase/PBaseDoc/Passwords
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
| Tape/disk: | Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 |
| Filename: | !AWApr94/Goodies/PowerBase/PBaseDoc/Passwords |
| Read OK: | ✔ |
| File size: | 238F bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
Password protection and related matters
=======================================
Powerbase is able to provide three levels of password protection. None of
the sample databases has any passwords set, so you may examine the password-
setting dialogue box which is accessed from the 'Miscellaneous' submenu. If
passwords have been defined then an attempt to open the database leads to a
request for a password. This is not readable as you type it in; all the
characters are replaced by hyphens. If Powerbase does not recognize the
supplied password it bleeps and prints an error message in red then prompts
for the password to be re-entered.
The lowest password level is 'Read'. A user opening a database with the
'Read' password will be allowed to browse and search, examine validation
tables and print lists, but not much else. Many of the buttons on the keypad
will be shaded (the same ones as are shaded during printing and indexing, in
fact) and so are quite a few menu items. In particular, the whole of the
'Miscellaneous' submenu is unavailable, thus preventing you from getting at
the other passwords!
The next level, 'Write', allows more operations. Everything on the keypad is
now allowed, including the altering, creation and deletion of records. You
may also create indices and create and edit validation tables. What you
still cannot do is change the other passwords or alter the size and
structure of the database by means of options on the icon bar menu.
The top level is 'Manager'. Now, at last, you are allowed to set and alter
passwords, as well as use all the icon bar menu options. Passwords may be up
to 10 characters long and are case-specific. Note that when you are setting
the two lower ones they can be read but the 'Manager' password appears even
here as a row of hyphens. Take care not to forget it! If no passwords at all
are set you have full 'Manager' rights so you may ignore the password
facility altogether if you are the only user of the database.
If you decide to use passwords you may not wish to use all three levels of
protection and are not compelled to do so. You may set a 'Manager' level
password only, leaving the other two blank. When you attempt to open the
database in such circumstances the password-entry window appears because
Powerbase can't read your mind and doesn't know whether you're the Manager
and wish to enter your password or whether you're a lower-level user being
given limited access without needing a password. If the latter you would
simply click on 'OK' or type RETURN, thus entering a null password. This
would give you 'Write' access. If you set the 'Manager' and 'Write'
passwords then entering a null password as described would give you 'Read'
access.
Of course it makes no sense to set a low-level password and leave a higher
level one blank! Powerbase will prevent you from doing this in the following
way. If there is a 'Read' password but no 'Write' password Powerbase makes
the 'Write' password the same as the one for 'Read'. Similarly, if there is
a 'Write' password and no 'Manager' password the latter is made the same as
the 'Write' password. This means that setting only the 'Read' password
actually makes all three passwords identical. At what level are you then
admitted when you enter this password? 'Manager', of course - otherwise you
could never get 'Manager' level access again! The rule is a simple one: when
two or more of the passwords are identical you are always given the higher
level rights when using that password.
Option buttons in the password-setting window
=============================================
As well as the icons for the three passwords you will see eight option
buttons or "switches" which may be used to enable or disable certain
features of Powerbase so that you can customise your database to some
extent. The reason for putting them here is that they may only be altered by
someone who has 'Manager' rights since that is the only access level which
allows you to open this dialogue box. All the switches except the last
('Log changes') are 'on' by default so that all the named features are
enabled. If you deselect any of these switches the feature concerned will
cease to operate immediately and will remain inoperative every time the
database is opened unless you set the switch to re-enable it.
The first switch determines whether or not the keypad is displayed when the
database is open. You might want to make a database application in which
only a limited selection of control buttons - perhaps 'start', 'end',
'next', 'previous' and 'search' - are to be used. This can be done by
placing the required buttons on the record screen itself (see 'Create') and
suppressing the keypad by deselecting its switch in the 'Passwords' window.
You might also wish to prevent the main menu and/or the icon-bar menu from
appearing when the user clicks MENU. Another switch stops the keystroke
equivalents of the keypad buttons from operating.
The fifth switch ('Data export') causes the 'Export subset' and 'Export CSV'
entries on the main menu to be shaded, thus cutting the user off from these
facilities. The sixth ('Reports') does the same for the 'Print' function.
Duplicate primary keys
----------------------
The last switch determines whether the database is allowed to have repeating
primary keys or not. As mentioned elsewhere ('Create') the primary key
should, ideally, be unique for each record. Sometimes the very nature of the
data will make it so but, if this is not the case, you can enforce primary
key uniqueness by deselecting this switch. Any attempt to enter a record
which would have a primary key identical to one which already exists will
then result in an error message and the new record will not be placed in the
file.
If you decide to allow duplicate primary keys (and this is the default,
remember) you might still want to be warned that such a key is about to be
created. The last choice on the icon-bar's 'Utilities' submenu allows you to
turn this warning on or off. When the item is ticked an attempt to create a
duplicate key causes a message to be displayed with the choice of cancelling
the operation or going ahead and accepting record with the repeated key. If
the item is not ticked the record is written to the file with no warning.
Note that this option is under 'Manager' control since that's the only level
which gives access to the 'Utilities' submenu.
Please note that the two paragraphs above refer only to the PRIMARY key.
Other, subsidiary, keys which are generated when you create an index on some
other field (see 'Indexing') are NOT subject to these restrictions and may
be repeated many times.
Log changes
-----------
When this switch is selected Powerbase will maintain a log which notes when
the database is opened and closed and details of many significant changes
made to the records. The following changes are logged:-
(1) Creation of a new record.
(2) Deletion of a record.
(3) Shifting a record to another subfile.
(4) Changing one or more fields in a record.
(5) Changing a field globally throughout a subfile.
(6) Creating an index.
(7) Balancing an index.
(8) Changing the primary key
(9) Reformatting the database.
(10) Merging data from another database.
(11) Importing CSV-type data.
Note that in cases (9)-(11) no details of the changes are logged; simply the
fact that the event took place and, in (10) and (11), the name of the source
database or file. Changes to validation tables are not logged. (6) and (7)
record the name of the index involved. (8) records the previous primary key
structure.
To start a log file select the switch in the 'Passwords' window. A 'Save'
box will appear offering you a default filename ("Log") and a default path
for the log file. The latter points to the database directory itself, so
simply clicking the 'OK' button in the 'Save' box, or typing RETURN, will
create an open file there called "Log". You may, of course, type in some
other name and drag the file icon to any filer window you wish. This is
especially useful if the database is used independently by several people
and you wish to vet its usage, since the pathname of the log file is never
displayed during normal use.
As long as the 'Log changes' switch remains selected the log file will be
opened whenever the database is opened. The title of the database is
recorded and the password level at which entry was achieved. This takes the
form of a number with the following meaning:-
0 no password required
1 read only
2 read/write
3 manager
The date and time is also recorded.
When you close the database the log file is also closed, the date and time
being again recorded.
All changes logged indicate in which subfile the change was made. If it
involves moving a record to a different subfile the destination subfile is
noted. When fields are altered both the old and new contents are logged.
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00000010 50 61 73 73 77 6f 72 64 20 70 72 6f 74 65 63 74 |Password protect|
00000020 69 6f 6e 20 61 6e 64 20 72 65 6c 61 74 65 64 20 |ion and related |
00000030 6d 61 74 74 65 72 73 0a 20 20 20 20 20 20 20 20 |matters. |
00000040 20 20 20 20 20 20 20 20 3d 3d 3d 3d 3d 3d 3d 3d | ========|
00000050 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
00000060 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a |===============.|
00000070 0a 50 6f 77 65 72 62 61 73 65 20 69 73 20 61 62 |.Powerbase is ab|
00000080 6c 65 20 74 6f 20 70 72 6f 76 69 64 65 20 74 68 |le to provide th|
00000090 72 65 65 20 6c 65 76 65 6c 73 20 6f 66 20 70 61 |ree levels of pa|
000000a0 73 73 77 6f 72 64 20 70 72 6f 74 65 63 74 69 6f |ssword protectio|
000000b0 6e 2e 20 4e 6f 6e 65 20 6f 66 0a 74 68 65 20 73 |n. None of.the s|
000000c0 61 6d 70 6c 65 20 64 61 74 61 62 61 73 65 73 20 |ample databases |
000000d0 68 61 73 20 61 6e 79 20 70 61 73 73 77 6f 72 64 |has any password|
000000e0 73 20 73 65 74 2c 20 73 6f 20 79 6f 75 20 6d 61 |s set, so you ma|
000000f0 79 20 65 78 61 6d 69 6e 65 20 74 68 65 20 70 61 |y examine the pa|
00000100 73 73 77 6f 72 64 2d 0a 73 65 74 74 69 6e 67 20 |ssword-.setting |
00000110 64 69 61 6c 6f 67 75 65 20 62 6f 78 20 77 68 69 |dialogue box whi|
00000120 63 68 20 69 73 20 61 63 63 65 73 73 65 64 20 66 |ch is accessed f|
00000130 72 6f 6d 20 74 68 65 20 27 4d 69 73 63 65 6c 6c |rom the 'Miscell|
00000140 61 6e 65 6f 75 73 27 20 73 75 62 6d 65 6e 75 2e |aneous' submenu.|
00000150 20 49 66 0a 70 61 73 73 77 6f 72 64 73 20 68 61 | If.passwords ha|
00000160 76 65 20 62 65 65 6e 20 20 64 65 66 69 6e 65 64 |ve been defined|
00000170 20 74 68 65 6e 20 61 6e 20 61 74 74 65 6d 70 74 | then an attempt|
00000180 20 74 6f 20 6f 70 65 6e 20 74 68 65 20 64 61 74 | to open the dat|
00000190 61 62 61 73 65 20 6c 65 61 64 73 20 74 6f 20 61 |abase leads to a|
000001a0 0a 72 65 71 75 65 73 74 20 66 6f 72 20 61 20 70 |.request for a p|
000001b0 61 73 73 77 6f 72 64 2e 20 20 54 68 69 73 20 69 |assword. This i|
000001c0 73 20 6e 6f 74 20 72 65 61 64 61 62 6c 65 20 61 |s not readable a|
000001d0 73 20 79 6f 75 20 74 79 70 65 20 69 74 20 69 6e |s you type it in|
000001e0 3b 20 61 6c 6c 20 74 68 65 0a 63 68 61 72 61 63 |; all the.charac|
000001f0 74 65 72 73 20 61 72 65 20 72 65 70 6c 61 63 65 |ters are replace|
00000200 64 20 62 79 20 68 79 70 68 65 6e 73 2e 20 49 66 |d by hyphens. If|
00000210 20 50 6f 77 65 72 62 61 73 65 20 64 6f 65 73 20 | Powerbase does |
00000220 6e 6f 74 20 72 65 63 6f 67 6e 69 7a 65 20 74 68 |not recognize th|
00000230 65 0a 73 75 70 70 6c 69 65 64 20 70 61 73 73 77 |e.supplied passw|
00000240 6f 72 64 20 69 74 20 62 6c 65 65 70 73 20 61 6e |ord it bleeps an|
00000250 64 20 70 72 69 6e 74 73 20 61 6e 20 65 72 72 6f |d prints an erro|
00000260 72 20 6d 65 73 73 61 67 65 20 69 6e 20 72 65 64 |r message in red|
00000270 20 74 68 65 6e 20 70 72 6f 6d 70 74 73 0a 66 6f | then prompts.fo|
00000280 72 20 74 68 65 20 70 61 73 73 77 6f 72 64 20 74 |r the password t|
00000290 6f 20 62 65 20 72 65 2d 65 6e 74 65 72 65 64 2e |o be re-entered.|
000002a0 0a 0a 54 68 65 20 6c 6f 77 65 73 74 20 70 61 73 |..The lowest pas|
000002b0 73 77 6f 72 64 20 6c 65 76 65 6c 20 69 73 20 27 |sword level is '|
000002c0 52 65 61 64 27 2e 20 41 20 75 73 65 72 20 6f 70 |Read'. A user op|
000002d0 65 6e 69 6e 67 20 61 20 64 61 74 61 62 61 73 65 |ening a database|
000002e0 20 77 69 74 68 20 74 68 65 0a 27 52 65 61 64 27 | with the.'Read'|
000002f0 20 70 61 73 73 77 6f 72 64 20 77 69 6c 6c 20 62 | password will b|
00000300 65 20 61 6c 6c 6f 77 65 64 20 74 6f 20 62 72 6f |e allowed to bro|
00000310 77 73 65 20 61 6e 64 20 73 65 61 72 63 68 2c 20 |wse and search, |
00000320 65 78 61 6d 69 6e 65 20 76 61 6c 69 64 61 74 69 |examine validati|
00000330 6f 6e 0a 74 61 62 6c 65 73 20 61 6e 64 20 70 72 |on.tables and pr|
00000340 69 6e 74 20 6c 69 73 74 73 2c 20 62 75 74 20 6e |int lists, but n|
00000350 6f 74 20 6d 75 63 68 20 65 6c 73 65 2e 20 4d 61 |ot much else. Ma|
00000360 6e 79 20 6f 66 20 74 68 65 20 62 75 74 74 6f 6e |ny of the button|
00000370 73 20 6f 6e 20 74 68 65 20 6b 65 79 70 61 64 0a |s on the keypad.|
00000380 77 69 6c 6c 20 62 65 20 73 68 61 64 65 64 20 28 |will be shaded (|
00000390 74 68 65 20 73 61 6d 65 20 6f 6e 65 73 20 61 73 |the same ones as|
000003a0 20 61 72 65 20 73 68 61 64 65 64 20 64 75 72 69 | are shaded duri|
000003b0 6e 67 20 70 72 69 6e 74 69 6e 67 20 61 6e 64 20 |ng printing and |
000003c0 69 6e 64 65 78 69 6e 67 2c 20 69 6e 0a 66 61 63 |indexing, in.fac|
000003d0 74 29 20 61 6e 64 20 73 6f 20 61 72 65 20 71 75 |t) and so are qu|
000003e0 69 74 65 20 61 20 66 65 77 20 6d 65 6e 75 20 69 |ite a few menu i|
000003f0 74 65 6d 73 2e 20 49 6e 20 70 61 72 74 69 63 75 |tems. In particu|
00000400 6c 61 72 2c 20 74 68 65 20 77 68 6f 6c 65 20 6f |lar, the whole o|
00000410 66 20 74 68 65 0a 27 4d 69 73 63 65 6c 6c 61 6e |f the.'Miscellan|
00000420 65 6f 75 73 27 20 73 75 62 6d 65 6e 75 20 69 73 |eous' submenu is|
00000430 20 75 6e 61 76 61 69 6c 61 62 6c 65 2c 20 74 68 | unavailable, th|
00000440 75 73 20 70 72 65 76 65 6e 74 69 6e 67 20 79 6f |us preventing yo|
00000450 75 20 66 72 6f 6d 20 67 65 74 74 69 6e 67 20 61 |u from getting a|
00000460 74 0a 74 68 65 20 6f 74 68 65 72 20 70 61 73 73 |t.the other pass|
00000470 77 6f 72 64 73 21 0a 0a 54 68 65 20 6e 65 78 74 |words!..The next|
00000480 20 6c 65 76 65 6c 2c 20 27 57 72 69 74 65 27 2c | level, 'Write',|
00000490 20 61 6c 6c 6f 77 73 20 6d 6f 72 65 20 6f 70 65 | allows more ope|
000004a0 72 61 74 69 6f 6e 73 2e 20 45 76 65 72 79 74 68 |rations. Everyth|
000004b0 69 6e 67 20 6f 6e 20 74 68 65 20 6b 65 79 70 61 |ing on the keypa|
000004c0 64 20 69 73 0a 6e 6f 77 20 61 6c 6c 6f 77 65 64 |d is.now allowed|
000004d0 2c 20 69 6e 63 6c 75 64 69 6e 67 20 74 68 65 20 |, including the |
000004e0 61 6c 74 65 72 69 6e 67 2c 20 63 72 65 61 74 69 |altering, creati|
000004f0 6f 6e 20 61 6e 64 20 64 65 6c 65 74 69 6f 6e 20 |on and deletion |
00000500 6f 66 20 72 65 63 6f 72 64 73 2e 20 59 6f 75 0a |of records. You.|
00000510 6d 61 79 20 61 6c 73 6f 20 63 72 65 61 74 65 20 |may also create |
00000520 69 6e 64 69 63 65 73 20 61 6e 64 20 63 72 65 61 |indices and crea|
00000530 74 65 20 61 6e 64 20 65 64 69 74 20 76 61 6c 69 |te and edit vali|
00000540 64 61 74 69 6f 6e 20 74 61 62 6c 65 73 2e 20 57 |dation tables. W|
00000550 68 61 74 20 79 6f 75 0a 73 74 69 6c 6c 20 63 61 |hat you.still ca|
00000560 6e 6e 6f 74 20 64 6f 20 69 73 20 63 68 61 6e 67 |nnot do is chang|
00000570 65 20 74 68 65 20 6f 74 68 65 72 20 70 61 73 73 |e the other pass|
00000580 77 6f 72 64 73 20 6f 72 20 61 6c 74 65 72 20 74 |words or alter t|
00000590 68 65 20 73 69 7a 65 20 61 6e 64 0a 73 74 72 75 |he size and.stru|
000005a0 63 74 75 72 65 20 6f 66 20 74 68 65 20 64 61 74 |cture of the dat|
000005b0 61 62 61 73 65 20 62 79 20 6d 65 61 6e 73 20 6f |abase by means o|
000005c0 66 20 6f 70 74 69 6f 6e 73 20 6f 6e 20 74 68 65 |f options on the|
000005d0 20 69 63 6f 6e 20 62 61 72 20 6d 65 6e 75 2e 0a | icon bar menu..|
000005e0 0a 54 68 65 20 74 6f 70 20 6c 65 76 65 6c 20 69 |.The top level i|
000005f0 73 20 27 4d 61 6e 61 67 65 72 27 2e 20 4e 6f 77 |s 'Manager'. Now|
00000600 2c 20 61 74 20 6c 61 73 74 2c 20 79 6f 75 20 61 |, at last, you a|
00000610 72 65 20 61 6c 6c 6f 77 65 64 20 74 6f 20 73 65 |re allowed to se|
00000620 74 20 61 6e 64 20 61 6c 74 65 72 0a 70 61 73 73 |t and alter.pass|
00000630 77 6f 72 64 73 2c 20 61 73 20 77 65 6c 6c 20 61 |words, as well a|
00000640 73 20 75 73 65 20 61 6c 6c 20 74 68 65 20 69 63 |s use all the ic|
00000650 6f 6e 20 62 61 72 20 6d 65 6e 75 20 6f 70 74 69 |on bar menu opti|
00000660 6f 6e 73 2e 20 50 61 73 73 77 6f 72 64 73 20 6d |ons. Passwords m|
00000670 61 79 20 62 65 20 75 70 0a 74 6f 20 31 30 20 63 |ay be up.to 10 c|
00000680 68 61 72 61 63 74 65 72 73 20 6c 6f 6e 67 20 61 |haracters long a|
00000690 6e 64 20 61 72 65 20 63 61 73 65 2d 73 70 65 63 |nd are case-spec|
000006a0 69 66 69 63 2e 20 4e 6f 74 65 20 74 68 61 74 20 |ific. Note that |
000006b0 77 68 65 6e 20 79 6f 75 20 61 72 65 20 73 65 74 |when you are set|
000006c0 74 69 6e 67 0a 74 68 65 20 74 77 6f 20 6c 6f 77 |ting.the two low|
000006d0 65 72 20 6f 6e 65 73 20 74 68 65 79 20 63 61 6e |er ones they can|
000006e0 20 62 65 20 72 65 61 64 20 62 75 74 20 74 68 65 | be read but the|
000006f0 20 27 4d 61 6e 61 67 65 72 27 20 70 61 73 73 77 | 'Manager' passw|
00000700 6f 72 64 20 61 70 70 65 61 72 73 20 65 76 65 6e |ord appears even|
00000710 0a 68 65 72 65 20 61 73 20 61 20 72 6f 77 20 6f |.here as a row o|
00000720 66 20 68 79 70 68 65 6e 73 2e 20 54 61 6b 65 20 |f hyphens. Take |
00000730 63 61 72 65 20 6e 6f 74 20 74 6f 20 66 6f 72 67 |care not to forg|
00000740 65 74 20 69 74 21 20 49 66 20 6e 6f 20 70 61 73 |et it! If no pas|
00000750 73 77 6f 72 64 73 20 61 74 20 61 6c 6c 0a 61 72 |swords at all.ar|
00000760 65 20 73 65 74 20 79 6f 75 20 68 61 76 65 20 66 |e set you have f|
00000770 75 6c 6c 20 27 4d 61 6e 61 67 65 72 27 20 72 69 |ull 'Manager' ri|
00000780 67 68 74 73 20 73 6f 20 79 6f 75 20 6d 61 79 20 |ghts so you may |
00000790 69 67 6e 6f 72 65 20 74 68 65 20 70 61 73 73 77 |ignore the passw|
000007a0 6f 72 64 0a 66 61 63 69 6c 69 74 79 20 61 6c 74 |ord.facility alt|
000007b0 6f 67 65 74 68 65 72 20 69 66 20 79 6f 75 20 61 |ogether if you a|
000007c0 72 65 20 74 68 65 20 6f 6e 6c 79 20 75 73 65 72 |re the only user|
000007d0 20 6f 66 20 74 68 65 20 64 61 74 61 62 61 73 65 | of the database|
000007e0 2e 0a 0a 49 66 20 79 6f 75 20 64 65 63 69 64 65 |...If you decide|
000007f0 20 74 6f 20 75 73 65 20 70 61 73 73 77 6f 72 64 | to use password|
00000800 73 20 79 6f 75 20 6d 61 79 20 6e 6f 74 20 77 69 |s you may not wi|
00000810 73 68 20 74 6f 20 75 73 65 20 61 6c 6c 20 74 68 |sh to use all th|
00000820 72 65 65 20 6c 65 76 65 6c 73 20 6f 66 0a 70 72 |ree levels of.pr|
00000830 6f 74 65 63 74 69 6f 6e 20 61 6e 64 20 61 72 65 |otection and are|
00000840 20 6e 6f 74 20 63 6f 6d 70 65 6c 6c 65 64 20 74 | not compelled t|
00000850 6f 20 64 6f 20 73 6f 2e 20 59 6f 75 20 6d 61 79 |o do so. You may|
00000860 20 73 65 74 20 61 20 27 4d 61 6e 61 67 65 72 27 | set a 'Manager'|
00000870 20 6c 65 76 65 6c 0a 70 61 73 73 77 6f 72 64 20 | level.password |
00000880 6f 6e 6c 79 2c 20 6c 65 61 76 69 6e 67 20 74 68 |only, leaving th|
00000890 65 20 6f 74 68 65 72 20 74 77 6f 20 62 6c 61 6e |e other two blan|
000008a0 6b 2e 20 57 68 65 6e 20 79 6f 75 20 61 74 74 65 |k. When you atte|
000008b0 6d 70 74 20 74 6f 20 6f 70 65 6e 20 74 68 65 0a |mpt to open the.|
000008c0 64 61 74 61 62 61 73 65 20 69 6e 20 73 75 63 68 |database in such|
000008d0 20 63 69 72 63 75 6d 73 74 61 6e 63 65 73 20 74 | circumstances t|
000008e0 68 65 20 70 61 73 73 77 6f 72 64 2d 65 6e 74 72 |he password-entr|
000008f0 79 20 77 69 6e 64 6f 77 20 61 70 70 65 61 72 73 |y window appears|
00000900 20 62 65 63 61 75 73 65 0a 50 6f 77 65 72 62 61 | because.Powerba|
00000910 73 65 20 63 61 6e 27 74 20 72 65 61 64 20 79 6f |se can't read yo|
00000920 75 72 20 6d 69 6e 64 20 61 6e 64 20 64 6f 65 73 |ur mind and does|
00000930 6e 27 74 20 6b 6e 6f 77 20 77 68 65 74 68 65 72 |n't know whether|
00000940 20 79 6f 75 27 72 65 20 74 68 65 20 4d 61 6e 61 | you're the Mana|
00000950 67 65 72 0a 61 6e 64 20 77 69 73 68 20 74 6f 20 |ger.and wish to |
00000960 65 6e 74 65 72 20 79 6f 75 72 20 70 61 73 73 77 |enter your passw|
00000970 6f 72 64 20 6f 72 20 77 68 65 74 68 65 72 20 79 |ord or whether y|
00000980 6f 75 27 72 65 20 61 20 6c 6f 77 65 72 2d 6c 65 |ou're a lower-le|
00000990 76 65 6c 20 75 73 65 72 20 62 65 69 6e 67 0a 67 |vel user being.g|
000009a0 69 76 65 6e 20 6c 69 6d 69 74 65 64 20 61 63 63 |iven limited acc|
000009b0 65 73 73 20 77 69 74 68 6f 75 74 20 6e 65 65 64 |ess without need|
000009c0 69 6e 67 20 61 20 70 61 73 73 77 6f 72 64 2e 20 |ing a password. |
000009d0 49 66 20 74 68 65 20 6c 61 74 74 65 72 20 79 6f |If the latter yo|
000009e0 75 20 77 6f 75 6c 64 0a 73 69 6d 70 6c 79 20 63 |u would.simply c|
000009f0 6c 69 63 6b 20 6f 6e 20 27 4f 4b 27 20 6f 72 20 |lick on 'OK' or |
00000a00 74 79 70 65 20 52 45 54 55 52 4e 2c 20 74 68 75 |type RETURN, thu|
00000a10 73 20 65 6e 74 65 72 69 6e 67 20 61 20 6e 75 6c |s entering a nul|
00000a20 6c 20 70 61 73 73 77 6f 72 64 2e 20 54 68 69 73 |l password. This|
00000a30 0a 77 6f 75 6c 64 20 67 69 76 65 20 79 6f 75 20 |.would give you |
00000a40 27 57 72 69 74 65 27 20 61 63 63 65 73 73 2e 20 |'Write' access. |
00000a50 49 66 20 79 6f 75 20 73 65 74 20 74 68 65 20 27 |If you set the '|
00000a60 4d 61 6e 61 67 65 72 27 20 61 6e 64 20 27 57 72 |Manager' and 'Wr|
00000a70 69 74 65 27 0a 70 61 73 73 77 6f 72 64 73 20 74 |ite'.passwords t|
00000a80 68 65 6e 20 65 6e 74 65 72 69 6e 67 20 61 20 6e |hen entering a n|
00000a90 75 6c 6c 20 70 61 73 73 77 6f 72 64 20 61 73 20 |ull password as |
00000aa0 64 65 73 63 72 69 62 65 64 20 77 6f 75 6c 64 20 |described would |
00000ab0 67 69 76 65 20 79 6f 75 20 27 52 65 61 64 27 0a |give you 'Read'.|
00000ac0 61 63 63 65 73 73 2e 0a 0a 4f 66 20 63 6f 75 72 |access...Of cour|
00000ad0 73 65 20 69 74 20 6d 61 6b 65 73 20 6e 6f 20 73 |se it makes no s|
00000ae0 65 6e 73 65 20 74 6f 20 73 65 74 20 61 20 6c 6f |ense to set a lo|
00000af0 77 2d 6c 65 76 65 6c 20 70 61 73 73 77 6f 72 64 |w-level password|
00000b00 20 61 6e 64 20 6c 65 61 76 65 20 61 20 68 69 67 | and leave a hig|
00000b10 68 65 72 0a 6c 65 76 65 6c 20 6f 6e 65 20 62 6c |her.level one bl|
00000b20 61 6e 6b 21 20 50 6f 77 65 72 62 61 73 65 20 77 |ank! Powerbase w|
00000b30 69 6c 6c 20 70 72 65 76 65 6e 74 20 79 6f 75 20 |ill prevent you |
00000b40 66 72 6f 6d 20 64 6f 69 6e 67 20 74 68 69 73 20 |from doing this |
00000b50 69 6e 20 74 68 65 20 66 6f 6c 6c 6f 77 69 6e 67 |in the following|
00000b60 0a 77 61 79 2e 20 49 66 20 74 68 65 72 65 20 69 |.way. If there i|
00000b70 73 20 61 20 27 52 65 61 64 27 20 70 61 73 73 77 |s a 'Read' passw|
00000b80 6f 72 64 20 62 75 74 20 6e 6f 20 27 57 72 69 74 |ord but no 'Writ|
00000b90 65 27 20 70 61 73 73 77 6f 72 64 20 50 6f 77 65 |e' password Powe|
00000ba0 72 62 61 73 65 20 6d 61 6b 65 73 0a 74 68 65 20 |rbase makes.the |
00000bb0 27 57 72 69 74 65 27 20 70 61 73 73 77 6f 72 64 |'Write' password|
00000bc0 20 74 68 65 20 73 61 6d 65 20 61 73 20 74 68 65 | the same as the|
00000bd0 20 6f 6e 65 20 66 6f 72 20 27 52 65 61 64 27 2e | one for 'Read'.|
00000be0 20 53 69 6d 69 6c 61 72 6c 79 2c 20 69 66 20 74 | Similarly, if t|
00000bf0 68 65 72 65 20 69 73 0a 61 20 27 57 72 69 74 65 |here is.a 'Write|
00000c00 27 20 70 61 73 73 77 6f 72 64 20 61 6e 64 20 6e |' password and n|
00000c10 6f 20 27 4d 61 6e 61 67 65 72 27 20 70 61 73 73 |o 'Manager' pass|
00000c20 77 6f 72 64 20 74 68 65 20 6c 61 74 74 65 72 20 |word the latter |
00000c30 69 73 20 6d 61 64 65 20 74 68 65 20 73 61 6d 65 |is made the same|
00000c40 20 61 73 0a 74 68 65 20 27 57 72 69 74 65 27 20 | as.the 'Write' |
00000c50 70 61 73 73 77 6f 72 64 2e 20 54 68 69 73 20 6d |password. This m|
00000c60 65 61 6e 73 20 74 68 61 74 20 73 65 74 74 69 6e |eans that settin|
00000c70 67 20 6f 6e 6c 79 20 74 68 65 20 27 52 65 61 64 |g only the 'Read|
00000c80 27 20 70 61 73 73 77 6f 72 64 0a 61 63 74 75 61 |' password.actua|
00000c90 6c 6c 79 20 6d 61 6b 65 73 20 61 6c 6c 20 74 68 |lly makes all th|
00000ca0 72 65 65 20 70 61 73 73 77 6f 72 64 73 20 69 64 |ree passwords id|
00000cb0 65 6e 74 69 63 61 6c 2e 20 41 74 20 77 68 61 74 |entical. At what|
00000cc0 20 6c 65 76 65 6c 20 61 72 65 20 79 6f 75 20 74 | level are you t|
00000cd0 68 65 6e 0a 61 64 6d 69 74 74 65 64 20 77 68 65 |hen.admitted whe|
00000ce0 6e 20 79 6f 75 20 65 6e 74 65 72 20 74 68 69 73 |n you enter this|
00000cf0 20 70 61 73 73 77 6f 72 64 3f 20 27 4d 61 6e 61 | password? 'Mana|
00000d00 67 65 72 27 2c 20 6f 66 20 63 6f 75 72 73 65 20 |ger', of course |
00000d10 2d 20 6f 74 68 65 72 77 69 73 65 20 79 6f 75 0a |- otherwise you.|
00000d20 63 6f 75 6c 64 20 6e 65 76 65 72 20 67 65 74 20 |could never get |
00000d30 27 4d 61 6e 61 67 65 72 27 20 6c 65 76 65 6c 20 |'Manager' level |
00000d40 61 63 63 65 73 73 20 61 67 61 69 6e 21 20 54 68 |access again! Th|
00000d50 65 20 72 75 6c 65 20 69 73 20 61 20 73 69 6d 70 |e rule is a simp|
00000d60 6c 65 20 6f 6e 65 3a 20 77 68 65 6e 0a 74 77 6f |le one: when.two|
00000d70 20 6f 72 20 6d 6f 72 65 20 6f 66 20 74 68 65 20 | or more of the |
00000d80 70 61 73 73 77 6f 72 64 73 20 61 72 65 20 69 64 |passwords are id|
00000d90 65 6e 74 69 63 61 6c 20 79 6f 75 20 61 72 65 20 |entical you are |
00000da0 61 6c 77 61 79 73 20 67 69 76 65 6e 20 74 68 65 |always given the|
00000db0 20 68 69 67 68 65 72 0a 6c 65 76 65 6c 20 72 69 | higher.level ri|
00000dc0 67 68 74 73 20 77 68 65 6e 20 75 73 69 6e 67 20 |ghts when using |
00000dd0 74 68 61 74 20 70 61 73 73 77 6f 72 64 2e 0a 0a |that password...|
00000de0 4f 70 74 69 6f 6e 20 62 75 74 74 6f 6e 73 20 69 |Option buttons i|
00000df0 6e 20 74 68 65 20 70 61 73 73 77 6f 72 64 2d 73 |n the password-s|
00000e00 65 74 74 69 6e 67 20 77 69 6e 64 6f 77 0a 3d 3d |etting window.==|
00000e10 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
*
00000e30 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 41 73 20 77 |===========.As w|
00000e40 65 6c 6c 20 61 73 20 74 68 65 20 69 63 6f 6e 73 |ell as the icons|
00000e50 20 66 6f 72 20 74 68 65 20 74 68 72 65 65 20 70 | for the three p|
00000e60 61 73 73 77 6f 72 64 73 20 79 6f 75 20 77 69 6c |asswords you wil|
00000e70 6c 20 73 65 65 20 65 69 67 68 74 20 6f 70 74 69 |l see eight opti|
00000e80 6f 6e 0a 62 75 74 74 6f 6e 73 20 6f 72 20 22 73 |on.buttons or "s|
00000e90 77 69 74 63 68 65 73 22 20 77 68 69 63 68 20 6d |witches" which m|
00000ea0 61 79 20 62 65 20 75 73 65 64 20 74 6f 20 65 6e |ay be used to en|
00000eb0 61 62 6c 65 20 6f 72 20 64 69 73 61 62 6c 65 20 |able or disable |
00000ec0 63 65 72 74 61 69 6e 0a 66 65 61 74 75 72 65 73 |certain.features|
00000ed0 20 6f 66 20 50 6f 77 65 72 62 61 73 65 20 73 6f | of Powerbase so|
00000ee0 20 74 68 61 74 20 79 6f 75 20 63 61 6e 20 63 75 | that you can cu|
00000ef0 73 74 6f 6d 69 73 65 20 79 6f 75 72 20 64 61 74 |stomise your dat|
00000f00 61 62 61 73 65 20 74 6f 20 73 6f 6d 65 0a 65 78 |abase to some.ex|
00000f10 74 65 6e 74 2e 20 54 68 65 20 72 65 61 73 6f 6e |tent. The reason|
00000f20 20 66 6f 72 20 70 75 74 74 69 6e 67 20 74 68 65 | for putting the|
00000f30 6d 20 68 65 72 65 20 69 73 20 74 68 61 74 20 74 |m here is that t|
00000f40 68 65 79 20 6d 61 79 20 6f 6e 6c 79 20 62 65 20 |hey may only be |
00000f50 61 6c 74 65 72 65 64 20 62 79 0a 73 6f 6d 65 6f |altered by.someo|
00000f60 6e 65 20 77 68 6f 20 68 61 73 20 27 4d 61 6e 61 |ne who has 'Mana|
00000f70 67 65 72 27 20 72 69 67 68 74 73 20 73 69 6e 63 |ger' rights sinc|
00000f80 65 20 74 68 61 74 20 69 73 20 74 68 65 20 6f 6e |e that is the on|
00000f90 6c 79 20 61 63 63 65 73 73 20 6c 65 76 65 6c 20 |ly access level |
00000fa0 77 68 69 63 68 0a 61 6c 6c 6f 77 73 20 79 6f 75 |which.allows you|
00000fb0 20 74 6f 20 6f 70 65 6e 20 74 68 69 73 20 64 69 | to open this di|
00000fc0 61 6c 6f 67 75 65 20 62 6f 78 2e 20 41 6c 6c 20 |alogue box. All |
00000fd0 74 68 65 20 73 77 69 74 63 68 65 73 20 65 78 63 |the switches exc|
00000fe0 65 70 74 20 74 68 65 20 6c 61 73 74 0a 28 27 4c |ept the last.('L|
00000ff0 6f 67 20 63 68 61 6e 67 65 73 27 29 20 61 72 65 |og changes') are|
00001000 20 27 6f 6e 27 20 62 79 20 64 65 66 61 75 6c 74 | 'on' by default|
00001010 20 73 6f 20 74 68 61 74 20 61 6c 6c 20 74 68 65 | so that all the|
00001020 20 6e 61 6d 65 64 20 66 65 61 74 75 72 65 73 20 | named features |
00001030 61 72 65 0a 65 6e 61 62 6c 65 64 2e 20 49 66 20 |are.enabled. If |
00001040 79 6f 75 20 64 65 73 65 6c 65 63 74 20 61 6e 79 |you deselect any|
00001050 20 6f 66 20 74 68 65 73 65 20 73 77 69 74 63 68 | of these switch|
00001060 65 73 20 74 68 65 20 66 65 61 74 75 72 65 20 63 |es the feature c|
00001070 6f 6e 63 65 72 6e 65 64 20 77 69 6c 6c 0a 63 65 |oncerned will.ce|
00001080 61 73 65 20 74 6f 20 6f 70 65 72 61 74 65 20 69 |ase to operate i|
00001090 6d 6d 65 64 69 61 74 65 6c 79 20 61 6e 64 20 77 |mmediately and w|
000010a0 69 6c 6c 20 72 65 6d 61 69 6e 20 69 6e 6f 70 65 |ill remain inope|
000010b0 72 61 74 69 76 65 20 65 76 65 72 79 20 74 69 6d |rative every tim|
000010c0 65 20 74 68 65 0a 64 61 74 61 62 61 73 65 20 69 |e the.database i|
000010d0 73 20 6f 70 65 6e 65 64 20 75 6e 6c 65 73 73 20 |s opened unless |
000010e0 79 6f 75 20 73 65 74 20 74 68 65 20 73 77 69 74 |you set the swit|
000010f0 63 68 20 74 6f 20 72 65 2d 65 6e 61 62 6c 65 20 |ch to re-enable |
00001100 69 74 2e 0a 0a 54 68 65 20 66 69 72 73 74 20 73 |it...The first s|
00001110 77 69 74 63 68 20 64 65 74 65 72 6d 69 6e 65 73 |witch determines|
00001120 20 77 68 65 74 68 65 72 20 6f 72 20 6e 6f 74 20 | whether or not |
00001130 74 68 65 20 6b 65 79 70 61 64 20 69 73 20 64 69 |the keypad is di|
00001140 73 70 6c 61 79 65 64 20 77 68 65 6e 20 74 68 65 |splayed when the|
00001150 0a 64 61 74 61 62 61 73 65 20 69 73 20 6f 70 65 |.database is ope|
00001160 6e 2e 20 59 6f 75 20 6d 69 67 68 74 20 77 61 6e |n. You might wan|
00001170 74 20 74 6f 20 6d 61 6b 65 20 61 20 64 61 74 61 |t to make a data|
00001180 62 61 73 65 20 61 70 70 6c 69 63 61 74 69 6f 6e |base application|
00001190 20 69 6e 20 77 68 69 63 68 0a 6f 6e 6c 79 20 61 | in which.only a|
000011a0 20 6c 69 6d 69 74 65 64 20 73 65 6c 65 63 74 69 | limited selecti|
000011b0 6f 6e 20 6f 66 20 63 6f 6e 74 72 6f 6c 20 62 75 |on of control bu|
000011c0 74 74 6f 6e 73 20 2d 20 70 65 72 68 61 70 73 20 |ttons - perhaps |
000011d0 27 73 74 61 72 74 27 2c 20 27 65 6e 64 27 2c 0a |'start', 'end',.|
000011e0 27 6e 65 78 74 27 2c 20 27 70 72 65 76 69 6f 75 |'next', 'previou|
000011f0 73 27 20 61 6e 64 20 27 73 65 61 72 63 68 27 20 |s' and 'search' |
00001200 2d 20 61 72 65 20 74 6f 20 62 65 20 75 73 65 64 |- are to be used|
00001210 2e 20 54 68 69 73 20 63 61 6e 20 62 65 20 64 6f |. This can be do|
00001220 6e 65 20 62 79 0a 70 6c 61 63 69 6e 67 20 74 68 |ne by.placing th|
00001230 65 20 72 65 71 75 69 72 65 64 20 62 75 74 74 6f |e required butto|
00001240 6e 73 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 |ns on the record|
00001250 20 73 63 72 65 65 6e 20 69 74 73 65 6c 66 20 28 | screen itself (|
00001260 73 65 65 20 27 43 72 65 61 74 65 27 29 20 61 6e |see 'Create') an|
00001270 64 0a 73 75 70 70 72 65 73 73 69 6e 67 20 74 68 |d.suppressing th|
00001280 65 20 6b 65 79 70 61 64 20 62 79 20 64 65 73 65 |e keypad by dese|
00001290 6c 65 63 74 69 6e 67 20 69 74 73 20 73 77 69 74 |lecting its swit|
000012a0 63 68 20 69 6e 20 74 68 65 20 27 50 61 73 73 77 |ch in the 'Passw|
000012b0 6f 72 64 73 27 20 77 69 6e 64 6f 77 2e 0a 59 6f |ords' window..Yo|
000012c0 75 20 6d 69 67 68 74 20 61 6c 73 6f 20 77 69 73 |u might also wis|
000012d0 68 20 74 6f 20 70 72 65 76 65 6e 74 20 74 68 65 |h to prevent the|
000012e0 20 6d 61 69 6e 20 6d 65 6e 75 20 61 6e 64 2f 6f | main menu and/o|
000012f0 72 20 74 68 65 20 69 63 6f 6e 2d 62 61 72 20 6d |r the icon-bar m|
00001300 65 6e 75 20 66 72 6f 6d 0a 61 70 70 65 61 72 69 |enu from.appeari|
00001310 6e 67 20 77 68 65 6e 20 74 68 65 20 75 73 65 72 |ng when the user|
00001320 20 63 6c 69 63 6b 73 20 4d 45 4e 55 2e 20 41 6e | clicks MENU. An|
00001330 6f 74 68 65 72 20 73 77 69 74 63 68 20 73 74 6f |other switch sto|
00001340 70 73 20 74 68 65 20 6b 65 79 73 74 72 6f 6b 65 |ps the keystroke|
00001350 0a 65 71 75 69 76 61 6c 65 6e 74 73 20 6f 66 20 |.equivalents of |
00001360 74 68 65 20 6b 65 79 70 61 64 20 62 75 74 74 6f |the keypad butto|
00001370 6e 73 20 66 72 6f 6d 20 6f 70 65 72 61 74 69 6e |ns from operatin|
00001380 67 2e 0a 0a 54 68 65 20 66 69 66 74 68 20 73 77 |g...The fifth sw|
00001390 69 74 63 68 20 28 27 44 61 74 61 20 65 78 70 6f |itch ('Data expo|
000013a0 72 74 27 29 20 63 61 75 73 65 73 20 74 68 65 20 |rt') causes the |
000013b0 27 45 78 70 6f 72 74 20 73 75 62 73 65 74 27 20 |'Export subset' |
000013c0 61 6e 64 20 27 45 78 70 6f 72 74 20 43 53 56 27 |and 'Export CSV'|
000013d0 0a 65 6e 74 72 69 65 73 20 6f 6e 20 74 68 65 20 |.entries on the |
000013e0 6d 61 69 6e 20 6d 65 6e 75 20 74 6f 20 62 65 20 |main menu to be |
000013f0 73 68 61 64 65 64 2c 20 74 68 75 73 20 63 75 74 |shaded, thus cut|
00001400 74 69 6e 67 20 74 68 65 20 75 73 65 72 20 6f 66 |ting the user of|
00001410 66 20 66 72 6f 6d 20 74 68 65 73 65 0a 66 61 63 |f from these.fac|
00001420 69 6c 69 74 69 65 73 2e 20 54 68 65 20 73 69 78 |ilities. The six|
00001430 74 68 20 28 27 52 65 70 6f 72 74 73 27 29 20 64 |th ('Reports') d|
00001440 6f 65 73 20 74 68 65 20 73 61 6d 65 20 66 6f 72 |oes the same for|
00001450 20 74 68 65 20 27 50 72 69 6e 74 27 20 66 75 6e | the 'Print' fun|
00001460 63 74 69 6f 6e 2e 0a 0a 44 75 70 6c 69 63 61 74 |ction...Duplicat|
00001470 65 20 70 72 69 6d 61 72 79 20 6b 65 79 73 0a 2d |e primary keys.-|
00001480 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00001490 2d 2d 2d 2d 2d 0a 54 68 65 20 6c 61 73 74 20 73 |-----.The last s|
000014a0 77 69 74 63 68 20 64 65 74 65 72 6d 69 6e 65 73 |witch determines|
000014b0 20 77 68 65 74 68 65 72 20 74 68 65 20 64 61 74 | whether the dat|
000014c0 61 62 61 73 65 20 69 73 20 61 6c 6c 6f 77 65 64 |abase is allowed|
000014d0 20 74 6f 20 68 61 76 65 20 72 65 70 65 61 74 69 | to have repeati|
000014e0 6e 67 0a 70 72 69 6d 61 72 79 20 6b 65 79 73 20 |ng.primary keys |
000014f0 6f 72 20 6e 6f 74 2e 20 41 73 20 6d 65 6e 74 69 |or not. As menti|
00001500 6f 6e 65 64 20 65 6c 73 65 77 68 65 72 65 20 28 |oned elsewhere (|
00001510 27 43 72 65 61 74 65 27 29 20 74 68 65 20 70 72 |'Create') the pr|
00001520 69 6d 61 72 79 20 6b 65 79 0a 73 68 6f 75 6c 64 |imary key.should|
00001530 2c 20 69 64 65 61 6c 6c 79 2c 20 62 65 20 75 6e |, ideally, be un|
00001540 69 71 75 65 20 66 6f 72 20 65 61 63 68 20 72 65 |ique for each re|
00001550 63 6f 72 64 2e 20 53 6f 6d 65 74 69 6d 65 73 20 |cord. Sometimes |
00001560 74 68 65 20 76 65 72 79 20 6e 61 74 75 72 65 20 |the very nature |
00001570 6f 66 20 74 68 65 0a 64 61 74 61 20 77 69 6c 6c |of the.data will|
00001580 20 6d 61 6b 65 20 69 74 20 73 6f 20 62 75 74 2c | make it so but,|
00001590 20 69 66 20 74 68 69 73 20 69 73 20 6e 6f 74 20 | if this is not |
000015a0 74 68 65 20 63 61 73 65 2c 20 79 6f 75 20 63 61 |the case, you ca|
000015b0 6e 20 65 6e 66 6f 72 63 65 20 70 72 69 6d 61 72 |n enforce primar|
000015c0 79 0a 6b 65 79 20 75 6e 69 71 75 65 6e 65 73 73 |y.key uniqueness|
000015d0 20 62 79 20 64 65 73 65 6c 65 63 74 69 6e 67 20 | by deselecting |
000015e0 74 68 69 73 20 73 77 69 74 63 68 2e 20 41 6e 79 |this switch. Any|
000015f0 20 61 74 74 65 6d 70 74 20 74 6f 20 65 6e 74 65 | attempt to ente|
00001600 72 20 61 20 72 65 63 6f 72 64 0a 77 68 69 63 68 |r a record.which|
00001610 20 77 6f 75 6c 64 20 68 61 76 65 20 61 20 70 72 | would have a pr|
00001620 69 6d 61 72 79 20 6b 65 79 20 69 64 65 6e 74 69 |imary key identi|
00001630 63 61 6c 20 74 6f 20 6f 6e 65 20 77 68 69 63 68 |cal to one which|
00001640 20 61 6c 72 65 61 64 79 20 65 78 69 73 74 73 20 | already exists |
00001650 77 69 6c 6c 0a 74 68 65 6e 20 72 65 73 75 6c 74 |will.then result|
00001660 20 69 6e 20 61 6e 20 65 72 72 6f 72 20 6d 65 73 | in an error mes|
00001670 73 61 67 65 20 61 6e 64 20 74 68 65 20 6e 65 77 |sage and the new|
00001680 20 72 65 63 6f 72 64 20 77 69 6c 6c 20 6e 6f 74 | record will not|
00001690 20 62 65 20 70 6c 61 63 65 64 20 69 6e 20 74 68 | be placed in th|
000016a0 65 0a 66 69 6c 65 2e 20 0a 0a 49 66 20 79 6f 75 |e.file. ..If you|
000016b0 20 64 65 63 69 64 65 20 74 6f 20 61 6c 6c 6f 77 | decide to allow|
000016c0 20 64 75 70 6c 69 63 61 74 65 20 70 72 69 6d 61 | duplicate prima|
000016d0 72 79 20 6b 65 79 73 20 28 61 6e 64 20 74 68 69 |ry keys (and thi|
000016e0 73 20 69 73 20 74 68 65 20 64 65 66 61 75 6c 74 |s is the default|
000016f0 2c 0a 72 65 6d 65 6d 62 65 72 29 20 79 6f 75 20 |,.remember) you |
00001700 6d 69 67 68 74 20 73 74 69 6c 6c 20 77 61 6e 74 |might still want|
00001710 20 74 6f 20 62 65 20 77 61 72 6e 65 64 20 74 68 | to be warned th|
00001720 61 74 20 73 75 63 68 20 61 20 6b 65 79 20 69 73 |at such a key is|
00001730 20 61 62 6f 75 74 20 74 6f 20 62 65 0a 63 72 65 | about to be.cre|
00001740 61 74 65 64 2e 20 54 68 65 20 6c 61 73 74 20 63 |ated. The last c|
00001750 68 6f 69 63 65 20 6f 6e 20 74 68 65 20 69 63 6f |hoice on the ico|
00001760 6e 2d 62 61 72 27 73 20 27 55 74 69 6c 69 74 69 |n-bar's 'Utiliti|
00001770 65 73 27 20 73 75 62 6d 65 6e 75 20 61 6c 6c 6f |es' submenu allo|
00001780 77 73 20 79 6f 75 20 74 6f 0a 74 75 72 6e 20 74 |ws you to.turn t|
00001790 68 69 73 20 77 61 72 6e 69 6e 67 20 6f 6e 20 6f |his warning on o|
000017a0 72 20 6f 66 66 2e 20 57 68 65 6e 20 74 68 65 20 |r off. When the |
000017b0 69 74 65 6d 20 69 73 20 74 69 63 6b 65 64 20 61 |item is ticked a|
000017c0 6e 20 61 74 74 65 6d 70 74 20 74 6f 20 63 72 65 |n attempt to cre|
000017d0 61 74 65 20 61 0a 64 75 70 6c 69 63 61 74 65 20 |ate a.duplicate |
000017e0 6b 65 79 20 63 61 75 73 65 73 20 61 20 6d 65 73 |key causes a mes|
000017f0 73 61 67 65 20 74 6f 20 62 65 20 64 69 73 70 6c |sage to be displ|
00001800 61 79 65 64 20 77 69 74 68 20 74 68 65 20 63 68 |ayed with the ch|
00001810 6f 69 63 65 20 6f 66 20 63 61 6e 63 65 6c 6c 69 |oice of cancelli|
00001820 6e 67 0a 74 68 65 20 6f 70 65 72 61 74 69 6f 6e |ng.the operation|
00001830 20 6f 72 20 67 6f 69 6e 67 20 61 68 65 61 64 20 | or going ahead |
00001840 61 6e 64 20 61 63 63 65 70 74 69 6e 67 20 72 65 |and accepting re|
00001850 63 6f 72 64 20 77 69 74 68 20 74 68 65 20 72 65 |cord with the re|
00001860 70 65 61 74 65 64 20 6b 65 79 2e 20 49 66 0a 74 |peated key. If.t|
00001870 68 65 20 69 74 65 6d 20 69 73 20 6e 6f 74 20 74 |he item is not t|
00001880 69 63 6b 65 64 20 74 68 65 20 72 65 63 6f 72 64 |icked the record|
00001890 20 69 73 20 77 72 69 74 74 65 6e 20 74 6f 20 74 | is written to t|
000018a0 68 65 20 66 69 6c 65 20 77 69 74 68 20 6e 6f 20 |he file with no |
000018b0 77 61 72 6e 69 6e 67 2e 0a 4e 6f 74 65 20 74 68 |warning..Note th|
000018c0 61 74 20 74 68 69 73 20 6f 70 74 69 6f 6e 20 69 |at this option i|
000018d0 73 20 75 6e 64 65 72 20 27 4d 61 6e 61 67 65 72 |s under 'Manager|
000018e0 27 20 63 6f 6e 74 72 6f 6c 20 73 69 6e 63 65 20 |' control since |
000018f0 74 68 61 74 27 73 20 74 68 65 20 6f 6e 6c 79 20 |that's the only |
00001900 6c 65 76 65 6c 0a 77 68 69 63 68 20 67 69 76 65 |level.which give|
00001910 73 20 61 63 63 65 73 73 20 74 6f 20 74 68 65 20 |s access to the |
00001920 27 55 74 69 6c 69 74 69 65 73 27 20 73 75 62 6d |'Utilities' subm|
00001930 65 6e 75 2e 0a 0a 50 6c 65 61 73 65 20 6e 6f 74 |enu...Please not|
00001940 65 20 74 68 61 74 20 74 68 65 20 74 77 6f 20 70 |e that the two p|
00001950 61 72 61 67 72 61 70 68 73 20 61 62 6f 76 65 20 |aragraphs above |
00001960 72 65 66 65 72 20 6f 6e 6c 79 20 74 6f 20 74 68 |refer only to th|
00001970 65 20 50 52 49 4d 41 52 59 20 6b 65 79 2e 0a 4f |e PRIMARY key..O|
00001980 74 68 65 72 2c 20 73 75 62 73 69 64 69 61 72 79 |ther, subsidiary|
00001990 2c 20 6b 65 79 73 20 77 68 69 63 68 20 61 72 65 |, keys which are|
000019a0 20 67 65 6e 65 72 61 74 65 64 20 77 68 65 6e 20 | generated when |
000019b0 79 6f 75 20 63 72 65 61 74 65 20 61 6e 20 69 6e |you create an in|
000019c0 64 65 78 20 6f 6e 20 73 6f 6d 65 0a 6f 74 68 65 |dex on some.othe|
000019d0 72 20 66 69 65 6c 64 20 28 73 65 65 20 27 49 6e |r field (see 'In|
000019e0 64 65 78 69 6e 67 27 29 20 61 72 65 20 4e 4f 54 |dexing') are NOT|
000019f0 20 73 75 62 6a 65 63 74 20 74 6f 20 74 68 65 73 | subject to thes|
00001a00 65 20 72 65 73 74 72 69 63 74 69 6f 6e 73 20 61 |e restrictions a|
00001a10 6e 64 20 6d 61 79 0a 62 65 20 72 65 70 65 61 74 |nd may.be repeat|
00001a20 65 64 20 6d 61 6e 79 20 74 69 6d 65 73 2e 0a 0a |ed many times...|
00001a30 4c 6f 67 20 63 68 61 6e 67 65 73 0a 2d 2d 2d 2d |Log changes.----|
00001a40 2d 2d 2d 2d 2d 2d 2d 0a 57 68 65 6e 20 74 68 69 |-------.When thi|
00001a50 73 20 73 77 69 74 63 68 20 69 73 20 73 65 6c 65 |s switch is sele|
00001a60 63 74 65 64 20 50 6f 77 65 72 62 61 73 65 20 77 |cted Powerbase w|
00001a70 69 6c 6c 20 6d 61 69 6e 74 61 69 6e 20 61 20 6c |ill maintain a l|
00001a80 6f 67 20 77 68 69 63 68 20 6e 6f 74 65 73 20 77 |og which notes w|
00001a90 68 65 6e 0a 74 68 65 20 64 61 74 61 62 61 73 65 |hen.the database|
00001aa0 20 69 73 20 6f 70 65 6e 65 64 20 61 6e 64 20 63 | is opened and c|
00001ab0 6c 6f 73 65 64 20 61 6e 64 20 64 65 74 61 69 6c |losed and detail|
00001ac0 73 20 6f 66 20 6d 61 6e 79 20 73 69 67 6e 69 66 |s of many signif|
00001ad0 69 63 61 6e 74 20 63 68 61 6e 67 65 73 0a 6d 61 |icant changes.ma|
00001ae0 64 65 20 74 6f 20 74 68 65 20 72 65 63 6f 72 64 |de to the record|
00001af0 73 2e 20 54 68 65 20 66 6f 6c 6c 6f 77 69 6e 67 |s. The following|
00001b00 20 63 68 61 6e 67 65 73 20 61 72 65 20 6c 6f 67 | changes are log|
00001b10 67 65 64 3a 2d 0a 0a 20 20 20 20 20 20 20 20 28 |ged:-.. (|
00001b20 31 29 20 43 72 65 61 74 69 6f 6e 20 6f 66 20 61 |1) Creation of a|
00001b30 20 6e 65 77 20 72 65 63 6f 72 64 2e 0a 20 20 20 | new record.. |
00001b40 20 20 20 20 20 28 32 29 20 44 65 6c 65 74 69 6f | (2) Deletio|
00001b50 6e 20 6f 66 20 61 20 72 65 63 6f 72 64 2e 0a 20 |n of a record.. |
00001b60 20 20 20 20 20 20 20 28 33 29 20 53 68 69 66 74 | (3) Shift|
00001b70 69 6e 67 20 61 20 72 65 63 6f 72 64 20 74 6f 20 |ing a record to |
00001b80 61 6e 6f 74 68 65 72 20 73 75 62 66 69 6c 65 2e |another subfile.|
00001b90 0a 20 20 20 20 20 20 20 20 28 34 29 20 43 68 61 |. (4) Cha|
00001ba0 6e 67 69 6e 67 20 6f 6e 65 20 6f 72 20 6d 6f 72 |nging one or mor|
00001bb0 65 20 66 69 65 6c 64 73 20 69 6e 20 61 20 72 65 |e fields in a re|
00001bc0 63 6f 72 64 2e 0a 20 20 20 20 20 20 20 20 28 35 |cord.. (5|
00001bd0 29 20 43 68 61 6e 67 69 6e 67 20 61 20 66 69 65 |) Changing a fie|
00001be0 6c 64 20 67 6c 6f 62 61 6c 6c 79 20 74 68 72 6f |ld globally thro|
00001bf0 75 67 68 6f 75 74 20 61 20 73 75 62 66 69 6c 65 |ughout a subfile|
00001c00 2e 0a 20 20 20 20 20 20 20 20 28 36 29 20 43 72 |.. (6) Cr|
00001c10 65 61 74 69 6e 67 20 61 6e 20 69 6e 64 65 78 2e |eating an index.|
00001c20 0a 20 20 20 20 20 20 20 20 28 37 29 20 42 61 6c |. (7) Bal|
00001c30 61 6e 63 69 6e 67 20 61 6e 20 69 6e 64 65 78 2e |ancing an index.|
00001c40 0a 20 20 20 20 20 20 20 20 28 38 29 20 43 68 61 |. (8) Cha|
00001c50 6e 67 69 6e 67 20 74 68 65 20 70 72 69 6d 61 72 |nging the primar|
00001c60 79 20 6b 65 79 0a 20 20 20 20 20 20 20 20 28 39 |y key. (9|
00001c70 29 20 52 65 66 6f 72 6d 61 74 74 69 6e 67 20 74 |) Reformatting t|
00001c80 68 65 20 64 61 74 61 62 61 73 65 2e 0a 20 20 20 |he database.. |
00001c90 20 20 20 20 28 31 30 29 20 4d 65 72 67 69 6e 67 | (10) Merging|
00001ca0 20 64 61 74 61 20 66 72 6f 6d 20 61 6e 6f 74 68 | data from anoth|
00001cb0 65 72 20 64 61 74 61 62 61 73 65 2e 0a 20 20 20 |er database.. |
00001cc0 20 20 20 20 28 31 31 29 20 49 6d 70 6f 72 74 69 | (11) Importi|
00001cd0 6e 67 20 43 53 56 2d 74 79 70 65 20 64 61 74 61 |ng CSV-type data|
00001ce0 2e 0a 0a 4e 6f 74 65 20 74 68 61 74 20 69 6e 20 |...Note that in |
00001cf0 63 61 73 65 73 20 28 39 29 2d 28 31 31 29 20 6e |cases (9)-(11) n|
00001d00 6f 20 64 65 74 61 69 6c 73 20 6f 66 20 74 68 65 |o details of the|
00001d10 20 63 68 61 6e 67 65 73 20 61 72 65 20 6c 6f 67 | changes are log|
00001d20 67 65 64 3b 20 73 69 6d 70 6c 79 20 74 68 65 0a |ged; simply the.|
00001d30 66 61 63 74 20 74 68 61 74 20 74 68 65 20 65 76 |fact that the ev|
00001d40 65 6e 74 20 74 6f 6f 6b 20 70 6c 61 63 65 20 61 |ent took place a|
00001d50 6e 64 2c 20 69 6e 20 28 31 30 29 20 61 6e 64 20 |nd, in (10) and |
00001d60 28 31 31 29 2c 20 74 68 65 20 6e 61 6d 65 20 6f |(11), the name o|
00001d70 66 20 74 68 65 20 73 6f 75 72 63 65 0a 64 61 74 |f the source.dat|
00001d80 61 62 61 73 65 20 6f 72 20 66 69 6c 65 2e 20 43 |abase or file. C|
00001d90 68 61 6e 67 65 73 20 74 6f 20 76 61 6c 69 64 61 |hanges to valida|
00001da0 74 69 6f 6e 20 74 61 62 6c 65 73 20 61 72 65 20 |tion tables are |
00001db0 6e 6f 74 20 6c 6f 67 67 65 64 2e 20 28 36 29 20 |not logged. (6) |
00001dc0 61 6e 64 20 28 37 29 0a 72 65 63 6f 72 64 20 74 |and (7).record t|
00001dd0 68 65 20 6e 61 6d 65 20 6f 66 20 74 68 65 20 69 |he name of the i|
00001de0 6e 64 65 78 20 69 6e 76 6f 6c 76 65 64 2e 20 28 |ndex involved. (|
00001df0 38 29 20 72 65 63 6f 72 64 73 20 74 68 65 20 70 |8) records the p|
00001e00 72 65 76 69 6f 75 73 20 70 72 69 6d 61 72 79 20 |revious primary |
00001e10 6b 65 79 0a 73 74 72 75 63 74 75 72 65 2e 20 0a |key.structure. .|
00001e20 0a 54 6f 20 73 74 61 72 74 20 61 20 6c 6f 67 20 |.To start a log |
00001e30 66 69 6c 65 20 73 65 6c 65 63 74 20 74 68 65 20 |file select the |
00001e40 73 77 69 74 63 68 20 69 6e 20 74 68 65 20 27 50 |switch in the 'P|
00001e50 61 73 73 77 6f 72 64 73 27 20 77 69 6e 64 6f 77 |asswords' window|
00001e60 2e 20 41 20 27 53 61 76 65 27 0a 62 6f 78 20 77 |. A 'Save'.box w|
00001e70 69 6c 6c 20 61 70 70 65 61 72 20 6f 66 66 65 72 |ill appear offer|
00001e80 69 6e 67 20 79 6f 75 20 61 20 64 65 66 61 75 6c |ing you a defaul|
00001e90 74 20 66 69 6c 65 6e 61 6d 65 20 28 22 4c 6f 67 |t filename ("Log|
00001ea0 22 29 20 61 6e 64 20 61 20 64 65 66 61 75 6c 74 |") and a default|
00001eb0 20 70 61 74 68 0a 66 6f 72 20 74 68 65 20 6c 6f | path.for the lo|
00001ec0 67 20 66 69 6c 65 2e 20 54 68 65 20 6c 61 74 74 |g file. The latt|
00001ed0 65 72 20 70 6f 69 6e 74 73 20 74 6f 20 74 68 65 |er points to the|
00001ee0 20 64 61 74 61 62 61 73 65 20 64 69 72 65 63 74 | database direct|
00001ef0 6f 72 79 20 69 74 73 65 6c 66 2c 20 73 6f 0a 73 |ory itself, so.s|
00001f00 69 6d 70 6c 79 20 63 6c 69 63 6b 69 6e 67 20 74 |imply clicking t|
00001f10 68 65 20 27 4f 4b 27 20 62 75 74 74 6f 6e 20 69 |he 'OK' button i|
00001f20 6e 20 74 68 65 20 27 53 61 76 65 27 20 62 6f 78 |n the 'Save' box|
00001f30 2c 20 6f 72 20 74 79 70 69 6e 67 20 52 45 54 55 |, or typing RETU|
00001f40 52 4e 2c 20 77 69 6c 6c 0a 63 72 65 61 74 65 20 |RN, will.create |
00001f50 61 6e 20 6f 70 65 6e 20 66 69 6c 65 20 74 68 65 |an open file the|
00001f60 72 65 20 63 61 6c 6c 65 64 20 22 4c 6f 67 22 2e |re called "Log".|
00001f70 20 59 6f 75 20 6d 61 79 2c 20 6f 66 20 63 6f 75 | You may, of cou|
00001f80 72 73 65 2c 20 74 79 70 65 20 69 6e 20 73 6f 6d |rse, type in som|
00001f90 65 0a 6f 74 68 65 72 20 6e 61 6d 65 20 61 6e 64 |e.other name and|
00001fa0 20 64 72 61 67 20 74 68 65 20 66 69 6c 65 20 69 | drag the file i|
00001fb0 63 6f 6e 20 74 6f 20 61 6e 79 20 66 69 6c 65 72 |con to any filer|
00001fc0 20 77 69 6e 64 6f 77 20 79 6f 75 20 77 69 73 68 | window you wish|
00001fd0 2e 20 54 68 69 73 20 69 73 0a 65 73 70 65 63 69 |. This is.especi|
00001fe0 61 6c 6c 79 20 75 73 65 66 75 6c 20 69 66 20 74 |ally useful if t|
00001ff0 68 65 20 64 61 74 61 62 61 73 65 20 69 73 20 75 |he database is u|
00002000 73 65 64 20 69 6e 64 65 70 65 6e 64 65 6e 74 6c |sed independentl|
00002010 79 20 62 79 20 73 65 76 65 72 61 6c 20 70 65 6f |y by several peo|
00002020 70 6c 65 0a 61 6e 64 20 79 6f 75 20 77 69 73 68 |ple.and you wish|
00002030 20 74 6f 20 76 65 74 20 69 74 73 20 75 73 61 67 | to vet its usag|
00002040 65 2c 20 73 69 6e 63 65 20 74 68 65 20 70 61 74 |e, since the pat|
00002050 68 6e 61 6d 65 20 6f 66 20 74 68 65 20 6c 6f 67 |hname of the log|
00002060 20 66 69 6c 65 20 69 73 20 6e 65 76 65 72 0a 64 | file is never.d|
00002070 69 73 70 6c 61 79 65 64 20 64 75 72 69 6e 67 20 |isplayed during |
00002080 6e 6f 72 6d 61 6c 20 75 73 65 2e 0a 0a 41 73 20 |normal use...As |
00002090 6c 6f 6e 67 20 61 73 20 74 68 65 20 27 4c 6f 67 |long as the 'Log|
000020a0 20 63 68 61 6e 67 65 73 27 20 73 77 69 74 63 68 | changes' switch|
000020b0 20 72 65 6d 61 69 6e 73 20 73 65 6c 65 63 74 65 | remains selecte|
000020c0 64 20 74 68 65 20 6c 6f 67 20 66 69 6c 65 20 77 |d the log file w|
000020d0 69 6c 6c 20 62 65 0a 6f 70 65 6e 65 64 20 77 68 |ill be.opened wh|
000020e0 65 6e 65 76 65 72 20 74 68 65 20 64 61 74 61 62 |enever the datab|
000020f0 61 73 65 20 69 73 20 6f 70 65 6e 65 64 2e 20 54 |ase is opened. T|
00002100 68 65 20 74 69 74 6c 65 20 6f 66 20 74 68 65 20 |he title of the |
00002110 64 61 74 61 62 61 73 65 20 69 73 0a 72 65 63 6f |database is.reco|
00002120 72 64 65 64 20 61 6e 64 20 74 68 65 20 70 61 73 |rded and the pas|
00002130 73 77 6f 72 64 20 6c 65 76 65 6c 20 61 74 20 77 |sword level at w|
00002140 68 69 63 68 20 65 6e 74 72 79 20 77 61 73 20 61 |hich entry was a|
00002150 63 68 69 65 76 65 64 2e 20 54 68 69 73 20 74 61 |chieved. This ta|
00002160 6b 65 73 20 74 68 65 0a 66 6f 72 6d 20 6f 66 20 |kes the.form of |
00002170 61 20 6e 75 6d 62 65 72 20 77 69 74 68 20 74 68 |a number with th|
00002180 65 20 66 6f 6c 6c 6f 77 69 6e 67 20 6d 65 61 6e |e following mean|
00002190 69 6e 67 3a 2d 0a 0a 20 20 20 20 20 20 20 20 20 |ing:-.. |
000021a0 20 20 20 20 20 20 20 30 20 20 20 20 20 20 20 6e | 0 n|
000021b0 6f 20 70 61 73 73 77 6f 72 64 20 72 65 71 75 69 |o password requi|
000021c0 72 65 64 0a 20 20 20 20 20 20 20 20 20 20 20 20 |red. |
000021d0 20 20 20 20 31 20 20 20 20 20 20 20 72 65 61 64 | 1 read|
000021e0 20 6f 6e 6c 79 0a 20 20 20 20 20 20 20 20 20 20 | only. |
000021f0 20 20 20 20 20 20 32 20 20 20 20 20 20 20 72 65 | 2 re|
00002200 61 64 2f 77 72 69 74 65 0a 20 20 20 20 20 20 20 |ad/write. |
00002210 20 20 20 20 20 20 20 20 20 33 20 20 20 20 20 20 | 3 |
00002220 20 6d 61 6e 61 67 65 72 0a 0a 54 68 65 20 64 61 | manager..The da|
00002230 74 65 20 61 6e 64 20 74 69 6d 65 20 69 73 20 61 |te and time is a|
00002240 6c 73 6f 20 72 65 63 6f 72 64 65 64 2e 0a 0a 57 |lso recorded...W|
00002250 68 65 6e 20 79 6f 75 20 63 6c 6f 73 65 20 74 68 |hen you close th|
00002260 65 20 64 61 74 61 62 61 73 65 20 74 68 65 20 6c |e database the l|
00002270 6f 67 20 66 69 6c 65 20 69 73 20 61 6c 73 6f 20 |og file is also |
00002280 63 6c 6f 73 65 64 2c 20 74 68 65 20 64 61 74 65 |closed, the date|
00002290 20 61 6e 64 20 74 69 6d 65 0a 62 65 69 6e 67 20 | and time.being |
000022a0 61 67 61 69 6e 20 72 65 63 6f 72 64 65 64 2e 0a |again recorded..|
000022b0 0a 41 6c 6c 20 63 68 61 6e 67 65 73 20 6c 6f 67 |.All changes log|
000022c0 67 65 64 20 69 6e 64 69 63 61 74 65 20 69 6e 20 |ged indicate in |
000022d0 77 68 69 63 68 20 73 75 62 66 69 6c 65 20 74 68 |which subfile th|
000022e0 65 20 63 68 61 6e 67 65 20 77 61 73 20 6d 61 64 |e change was mad|
000022f0 65 2e 20 49 66 20 69 74 0a 69 6e 76 6f 6c 76 65 |e. If it.involve|
00002300 73 20 6d 6f 76 69 6e 67 20 61 20 72 65 63 6f 72 |s moving a recor|
00002310 64 20 74 6f 20 61 20 64 69 66 66 65 72 65 6e 74 |d to a different|
00002320 20 73 75 62 66 69 6c 65 20 74 68 65 20 64 65 73 | subfile the des|
00002330 74 69 6e 61 74 69 6f 6e 20 73 75 62 66 69 6c 65 |tination subfile|
00002340 20 69 73 0a 6e 6f 74 65 64 2e 20 57 68 65 6e 20 | is.noted. When |
00002350 66 69 65 6c 64 73 20 61 72 65 20 61 6c 74 65 72 |fields are alter|
00002360 65 64 20 62 6f 74 68 20 74 68 65 20 6f 6c 64 20 |ed both the old |
00002370 61 6e 64 20 6e 65 77 20 63 6f 6e 74 65 6e 74 73 |and new contents|
00002380 20 61 72 65 20 6c 6f 67 67 65 64 2e 0a 20 0a | are logged.. .|
0000238f 
.