Estimate Works Setting the Data Source

Your software is shipped with a new database that is ready to use. With Estimate Works for Word Enterprise Version, the database is now configurable for a network and does not have to remain in the 'C:\Users\Public\Documents\Estimate Works V6\db\' subdirectory where the Estimate Works are first installed order to function. The database file is a Microsoft Access 97 file, the file has no password and can be easily imported into most accounting or spreadsheet programs.

When you first install Estimate Works, the database (estimate.mdb) used to store your records and sample data will be installed in a sub directory ('C:\Users\Public\Documents\Estimate Works V6\db\'). If you wish to move the database to another location on the computer, or connect to a database already on another computer, you will need to set the path to the new data source.

Changing the path to the database can be easily accomplished using the Set Data Source form accessed through Administration - Set Data Source.

When you open the form, you will see the directory path to the database you are currently connected to in the Current Database Name and Path field. To connect to a different database, click the 'Locate Data Source' button. Browse to the new database on the open window and click 'Open'. If you have selected a file, it will now be displayed in the New Database Name and Path field. If your selection is correct, click the 'Apply' button. Estimate Works will now restart and you will be connected to the new database you have selected. *Note: Close all open forms in the Estimate Works program before changing the data source.

If the file you have connected to is not a valid Estimate Works database, you will be shown this form again when the program restarts to enable you to make another choice.

Network Installations: If you will be using this program on a network, you may wish to move the database to the computer you have designated as a file server. It is recommended that you install the software on each workstation (as limited by your software license agreement), then set the data source path to the main database on the file server immediately after the installation. Note: If you receive the Set Data Source form when starting your program on a network installation, first check to make sure that your network connection to the computer where the database is located has not been broken before attempting to change your Estimate Works settings.

Related Topics:

Installing Estimate Works