Appendix 5. Setting up the External plates database in «dbf» format.

To set up the External plates database in "dbf" format do the following:

1. Call for a dialog window Program launch or go to the Start menu and select Run or use the key combination «WIN»+«R» (Fig. 10.3—1).

Fig. 10.3—1 Program run dialog window

1. Enter «regedit» in the appeared window.
2. Click «ОK».
3. «Registry Editor» will open in result (Fig. 10.3—2).

Fig. 10.3—2 Registry editor dialog window
Note. Detailed information about Registry Editor is given in the section «Operation with OS Windows system register » of the document«Intellect program complex: Administrator guide».

1. In the register tree select «HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Xbase» (Fig. 10.3—3).

Fig. 10.3—3 Addng the parameter to the register

1. Select the menu point «Edit»  «Create»  «DWORD parameter».
2. Assign a name to a new DWORD parameter. For this enter the name in the «BDE» in the activated field, where on default the name «New parameter №1» has already been entered, and then click a mouse in anywhere in the Registry Editor dialog window. The entered name of the new DWORD parameter will be automatically saved.
3. Set the value to the new string parameter. Make a double click with a left mouse key upon the parameter's name for this. Edit DWORD value will open in result (Fig. 10.3—4).

Fig. 10.3—4 Edit DWORD value

1. 1. Assign 2 value to the «BDE» parameter (Fig. 10.3—4, 1).
   2. Click «OK» to save the changes (Fig. 10.3—4, 2).
2. DWORD «BDE» parameter will be created in result of operations in the registry (Fig. 10.3—3, 2).
3. To set up the connection to the external database do the following operation in the Data Link properties window:
   1. Go to the «Provider» tab (Fig. 10.3—5).

Fig. 10.3—5 Setting up the data provider

1. 1. From the «Providers OLE DB» list select the «Microsoft Jet 4.0 OLE DB Provider» point.
   2. Then go to the «All» tab (Fig. 10.3—6, 1).
   3. Set the path to «.dbf» files in the «Data Source» value range(Fig. 10.3—6, 2).

Fig. 10.3—6 All tab

1. 1. In the value range «Extended Properties» state «dBase IV;COUNTRY=0;CP=1252:LANGID=0x0409» (Fig. 10.3—6, 3).

Note. The value «COUNTRY=0;CP=1252:LANGID=0x0409» is stated only in case of being stored in DOS- coding.

1. 1. To change the property value click the «Change value…» button (Fig. 10.3—6, 4).
   2. In the opened «Edit property value» window enter the changes in the «Property value» field (Fig. 10.3—7, 1).
   3. Click Ok to save the changes (Fig. 10.3—7, 2).

Fig. 10.3—7Edit property value

1. 1. Click OK to close the window «Edit property value» (Fig. 10.3—6, 5).

As the result the External Plates Database in "dbf" format has been setup.