Click Setup on the Main menu to see the Setup form. Enter your company contact info and ImportFolder. You can click on any blue links on the form. Hover over them to see what they do. Website browses to your website. ImportFolder opens your import folder so you can drag files into it.

To view any raw table in the system, select it in the Table combo and click View or to export it to CSV, DBF (dBase, FoxPro, Clipper), HTM (for web browsers), MDB (Access), RTF (Word or WordPad), SNP (free Access reader from Microsoft), TXT or XLS (Excel) formats.

While viewing a table, you can drag the column headers into the order you want, highlight several columns together and right click, sort A-Z or Z-A. When you are done viewing, answer NO when asked if you want to save the table layout.

Click TblDoc to create a data dictionary defining all fields in the database application. This HTML file is opened in the user's browser.

The User form lets the Super user add or edit users. Normal users are limited in the data they can edit on themselves, but they can change their password here.

More info on setting up users

Click Link to change where the data tables are located. If you see the box asking where the data tables are upon opening the database, you may have a network error and should call for support to avoid storing your work in the wrong location.

Backup quickly saves a copy of the data tables to another location such as a flash drive.

Click Quit to force users out of the database for maintenance.

Compact rebuilds the indexes, repairs and reduces the size of the tables database. This requires exclusive access to the database, so it is best done after work. You can use the Quit function if people are widely distributed. If you change lots of data, you will notice improved performance if you compact weekly.

Database Application in Dallas, TX

Accounts are normally added upon import. The account will be used for that distributor in future imports.

General Ledger records are imported and used to determine commissions.

You can View (read only), Export or Select records in a query on the Data (Data Integrity) form.

This is a list of data integrity queries currently available. Those that start with I_ are for information only. Others shoud be resolved.

Close