dBworx Frequently Asked Questions --
Q: Are there file size limitations?
A: dBworx currently has a maximum of fifty fields per record -- however this limit can and
probably will be changed in future releases. As far as the number of records per file,
there isn't any limitation -- however certain operations may be a little slower for
very large files. Opening and loading a file is the main place you might see a slow-up;
for example a dBworx database containing 50,000 records will take about 45 to 50 seconds
to load on an older 266 MHz system.
Q: Why use dBworx instead of a commercial database?
A: Obviously dBworx doesn't have all the features of the large commercial packages
(at least not yet!) -- but it does have certain advantages:
* Small size (about 1 MB)
* No external DLLs, etc. required
* Installs without making registry entries
* Designed to be as simple as possible to use
* Reasonably priced (only $24.95 for the
* Provides the standard database functions
(search, sort, filter, import, export)
* Has a customizable help file
* Application packages are being developed
to run on dBworx and will be available
free to registered users
Q: Why pay for the registered version?
A: The registered version has a number of features that aren't in the freeware distribution,
* ODBC connectivity
* Different report formats
* Additional filtering options
* More options for formula calculations
* "Action" menu for mass updating of
* Built-in applications
* Ability to duplicate records
Q: How do I set up a dBworx file?
A: Start by clicking the "Create new file" button on the main screen. A "Save As" dialog will
pop up to let you enter a name for your new file (e.g., "Contacts" or "January Invoices",
etc.). Once a file name has been entered, the "design" screen will appear. For each
field you want to set up, just click on "Append record" and enter the information about
that field (field description, type, etc.). When you've set up all the fields for
your file, click the "Save/Exit" button to return to the main screen. At that point you'll
see the column headings in the box on the right corresponding to the field
descriptions you entered. You're now in entry mode - click on "Append record" and
start keying your first record. (Note: if you made a mistake in your setup, click on the
"Data file structure" button -- the design screen will reappear and you can edit your field
Q: What's the difference between inserting and appending a record?
A: If you select to append a new record, that record will be added to the end of the file.
If you select to insert a new record, that record will be added BEFORE the currently
selected record (the highlighted record in the list box on the right side of the screen).
Q: Can I key information directly into the list box on the right side of the main screen
(where all the database records are displayed)?
A: No you can't -- to help make the current record more visible, when you click on a
record in the box on the right or select to add a new record dBworx displays the
individual fields for that record in the current record box on the left. As you key
each field, the entries you make are immediately mirrored in the actual record on
the right side of the screen. Note that you can move downward from one field to the next
just by hitting the "Enter" key, and you can move up to a previous field by pressing
the "Page Up" key.
Q: Can I sort items in both ascending and descending order?
A: Yes -- click the "Records" menu, then select either "Sort Ascending" or "Sort Descending".
Q: Can I sort using multiple key fields?
A: Yes -- currently you can sort using up to three fields as keys.
Q: How can I pick out those records that meet two or more different criteria (for example,
all customers named "Smith" who have a phone number in the "918" area code)?
A: Run the "Select filter" option (under the "Records" menu) twice -- once to select all
customers named "Smith" and a second time to pick out just those with a "918" area code.
Q: What if I just want to pick out a range of records?
A: Select "Set filter" from the records menu, then choose "Select a range of records"
and enter the beginning and ending record numbers.
Q: Can I duplicate records?
A: Yes -- right-click on the record you want to copy and answer "Yes" when dBworx asks
if you want to duplicate the record.
Q: What about reports?
A: You can design your own report layouts with dBworx and save them to use over again.
Q: Can dBworx print mailing labels?
A: Yes, dBworx can print standard 1 x 2 5/8 inch laser labels (30 per sheet).
For other formats you can export your data to a delimited file, then import it into
Microsoft Word and use the "mail merge" function in Word.
Q: What if one of my dBworx files gets overwritten?
A: The best answer is just to take regular backups to diskette, CD or tape. Of course
you can also use the "Save As" function in dBworx to periodically save your files to backup files.
Q: What file names do I include in a backup?
A: dBworx data file names end in one of the following extensions - dwh, dwd, dwm, or dwr
Q: What if I want to copy just certain fields from one file over to a new dBworx file?
A: Open your dBworx file and select "Save As" and enter the name of the new file you want
to create. Once the new file has been created, click on the "Data File Structure" button
and (in the design screen) delete the fields you don't want. Then click the "Save/Exit"
button to return to the Entry screen.