Most recent edit on 2007-07-04 22:09:02 by NorbertGutscher [changes of a troll killed]
Additions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl+P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "%Access%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access key" click Yes.
Deletions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "¬cess%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access key" click Yes.
Edited on 2007-07-04 10:32:57 by CttAk6
Additions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "¬cess%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access key" click Yes.
Deletions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl+P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "%Access%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access key" click Yes.
Edited on 2005-07-18 17:28:07 by GroupsMBM [tiny correction]
Additions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl+P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "%Access%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access key" click Yes.
Deletions:
1) Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl+P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "%Access%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access ey" click Yes.
Oldest known version of this page was edited on 2005-07-17 19:44:22 by NorbertGutscher []
Page view:
Locking Btrieve
Initially by Steve Blank 2005-07-17
- The name of your user security file is found in Magic, Settings, Environment, Line 10 on the External tab. Make a backup copy of this file for safe keeping.
- Make a backup copy of your application control file.
- Launch Magic; select Settings, Logon from the pulldown menus; enter "supervisor" in the User ID box (without the double quotes) and click OK.
- Select Settings, User IDs from the pulldown menu; click on the Password cell in the SUPERVISOR user's line and press F5; type a password and press Enter; confirm the password and press Enter; click OK. Write down this password in your private notes.
- Select Settings, Secret Names from the pulldown menu and press F4 to create a new line; enter a name for your new Secret name (for example, "Access"); enter a Translation for your new Secret Name (for example, "R43gT66f"); use no double quotes and remember that Btrieve Owner Names are limited to no more than eight haracters. Write down this Secret Name and its Translation in your private notes.
- Open your application and its Tables Repository; one by one, highlight each of your table definitions and press Ctrl+P to open the highlighted table's Properties dialog; in the Access Key box on the Advanced tab, enter the Secret Name in the same format as you would a Logical Name (for example, "%Access%" but again without the double quotes); if you also want the data files to be encrypted as well, change Encrypt Table = Yes, else, leave Encrypt Table = No; click OK; when Magic prompts you with "Should access to the table require an Access ey" click Yes.
- Close your application and exit Magic.
- Copy the user security file and the application control file to your customer's site, replacing their existing user security and application control files.
Wait - you're not done yet - you still need to set Owner Names and Levels on the existing Btrieve data files. If you chose to have your data files encrypted as well as secured, you will need to set an Owner Name Level of "2", else "0" (zero, not the letter "O"). Here's how to finish the job:
Create a simple text file having one line for each of your Btrieve data files, each line of which is in the following format:
-setowner [filename] /O[ownername] [level] <end>
For example, in order to set a Level 0 (not encrypted) Owner Name of "R43gT66f" on a data file named "CUSTOMERS.MKD", the command line should be as follows:
-setowner customers.mkd /OR43gT66f 0 <end>
Remember, Owner Names are case-sensitive. Also, the command line terminator "<end>" is ALSO case-sensitive.
Place a copy of this text file on your customer's computer in the same location as that in which the existing Btrieve data files are stored - you can name this file anything you choose.
Sitting at the computer where the existing Btrieve data files are stored, open a command prompt and change to the directory wherein the Btrieve data files are stored; execute the following command:
BUTIL @[commandfile] [outputfile]
where
[commandfile] is the name of the text file you created in the previous step. After this command has completed, use your favorite text editor to open the file named in
[outputfile] to see the results of each command - all should say "command completed successfully".
IMPORTANT:
Be sure to delete the command line file after you're finished - you wouldn't want to leave your Btrieve data files' Owner Name floating around in plain text. Also, it would probably be a good idea to back up the Btrieve data files before executing BUTIL and, if you do, take these backup copies with you when you leave.
Steve Blank
