Tips and Tricks

If you have any tips that you would find useful to other users Notify me Del@dbfutils.com

1. Get rid of index bloat by going to the Structure window and click “Save Index”, this will delete your index file and recreate it.
2. To register dbfUtils with *.dbf files so you can double click on a table and open it press Ctrl +Shift +Alt + R while dbfUtils is running.
   To un-register dbfUtils with *.dbf files press Ctrl +Shift +Alt + U while dbfUtils is running.
3. Change the order of your fields by going to the left most columns on the Table Structure Grid and drag the row up or down.
4. To make dbfUtils run faster Go to setup on the menu, select Setup Apollo Client and select Commit Level None. Warning – do not use this mode in multi-user or client/server mode.
5. Do you have any NSX or CDX indexes with different names then your table? You can open them by adding this to the setup section of dbfUtils.ini which is in your dbfUtil’s application directory.
   [Setup]  < this is the existing section where to add
   Index=1   < add this.
   This will put an Open Index item under the File menu. Warning – if you open an index that does not belong to the current table it causes an AV error and you will have to quit dbfUtils and restart.
6. Control+D toggles delete record/recall record.