Applies To:
  • CitectSCADA 3.xx, 4.xx, 5.xx
Summary:
I installed Steeplechase MMI to its default directory so my projects reside in the path: C:\Program Files\VLC\VlcMMI 5_20\User\ which evidently contains spaces. I have associated the .DBF file extension with the MS Excel application so normally I can double click on a file with a .dbf extension and it will launch Excel. I want to edit my variable.dbf file via this method but it appears that Excel gets hung up on the spaces in the path and it does not launch when I double click on the file. If I launch Excel first I can use the File Open menu option to browse to C:\Program Files\VLC\VlcMMI 5_20\User\MyProject\variable.dbf successfully. This is a nuisance when I want to manually edit my databases. 

Solution:
You can rectify this by manually editing the Association of the DBF file extention. In the Windows Explorer go to View Menu and select Options. Select the File Types tab and highlight the first entry in the list and scroll down each entry whilst observing the 'Extension' field in the 'File Type Details' box, until you find the DBF extension. (You should see that it also says 'Opens with: Excel') Highlight this entry and push the Edit button and then push the Edit button on the new form that pops up. In the 'Action' field you should see "OPEN" and in the 'Application used to perform action:' field you will see something like: "C:\Program Files\Microsoft Office\Office\Excel.exe"

Add "%1" to the end of the application path. e.g. "C:\Program Files\Microsoft Office\Office\Excel.exe" "%1"

Note that if for some reason you cant find a DBF file type in the list then try adding one in using the 'New Type' button and you'll get an error message telling you one already exists and it will give you the name of it. Search the registry for this name and delete it. (It will probably be called 'dbf_auto_file') You will then be able to add your own DBF Association entry via the 'New Type' button with the properties shown above.

 
Keywords:
 

Attachments