If you encounter database problems that are not resolved using any of the database utilities in the program, it may be necessary to erase the database and build a new one entirely, which will resemble the fresh database that appears immediately after the software is first installed.

As a last resort, the entire database can be corrected by refreshing with an entirely new database. This will fix all errors with your current database. Note: It could be that a particular chart is causing your problems. Do you have any charts with names that are particularly long, like over 30 characters? In some cases, this is the cause of database problems, so you may wish to rename any long-titled charts, which you can do from the Object Editor (which is available from the Open menu).

Before you refresh your database, you may wish to backup your charts and quote pages, unless you do not mind rebuilding them. You use can use the Object Editor to export charts if desired. If you need help backing up your charts, let us know before you proceed with the following.

You will also want to save your Quote Page(s). Use the Object Editor as well to export quote pages. Most importantly is the ".All Symbols" quote page, but you may also have custom quotes pages that you want to keep. If you do not export your quote pages, all you have to do is re-enter your symbols on the new quote page after the database is reset.

When you are ready to start with a new database:

First, close the MarketDelta program before proceeding.

If you using Windows XP: Delete the C:\Program Files\mktdelta\data_f folder, then re-install the software. This will create a new database that is fresh, without errors. You can download the software from our website.

If you are using Windows Vista or Windows 7: Delete or rename folder named "data_f" in the C:\Users\username\Marketdelta folder. Then simply open MarketDelta again, as there is no need to run the installer. It will create a new database when you open the program. Note that this location for data_f is different than in the XP case, even though a data_f also exists in Program Files. However, the actual database in Windows Vista/7 is stored in the C:\Users\username\Marketdelta.

Once you are done, a new database is created, without your custom charts or quote pages. You can then import your charts that you previously exported, by using the File menu Import utility.

This process creates an entirely new database. If, after you do this, you still have database errors, one of your saved/imported charts is likely to blame. It can be tricky tracking down which chart has become corrupt. You can follow the "Further Troubleshooting Steps" in this article:

http://support.marketdelta.com/entries/121568