The H2OS Recovery Console


The H2OS Recovery Console is an executable included with the H2OS installation (C:\H2OS\H2OS_RECOVER.EXE) or can be downloaded from the H2OS Website



To launch the H2OS recovery console use Windows Explorer. Navigate to find and launch the recover program (C:\H2OS\H2OS_RECOVER.EXE)  


The Recovery Console screen:





Figure 1  The H2OS Recovery Console


The H2OS recovery console provides access to some features which can be helpful to recover from a system failure



Launching the H2OS Recovery Console


The H2OS Recovery Console is installed in the H2OS root (installation) folder


The H2OS Recovery Console can be started using Windows Explorer. To do so, locate and double-click the file name c:\h2os\h2os_recover.exe. You can also copy the desktop shortcut provided as a file named "c:\h2os\h2os recover (file type is "Shortcut")" to your desktop using Windows Explorer.









Apply database structure changes


Checks to see that all database structure changes distributed to date have actually been installed on this H2OS installation. If changes have been made, no action is taken. If change had not been made it will be made during the next H2OS startup.



Browse or Edit a database table





Click the command button to the right to use the Windows navigator to select a table (DBF) to be viewed. The selected

DBF table name will appear in this textbox.


When a table has been selected, click the EDIT or BROWSE command button below the selected table name



Change the current database



This command use the Windows Navigator to select the H2OS Customers table (REALCUS.DBF) to be opened during the next H2OS startup.


In most installations the customer table is located at c:\h2os\cl\h2os\realcus.dbf. For multiple H2OS installations the root folder name will be different for each installation, e.g. H2OS_MYCO, H2OS_YOURCO, etc.


The Customers table is sometimes referred to as CUSTLIST


Internally, this command will change the Operators profile to make the selected customers table the current database when H2OS is re-started.



Command window



Launches a Visual FoxPro command window. Use only on advice from H2OS customer support. To close this window enter QUIT.



Disconnect from LAN



When reconnecting to LAN server, use setup->options->network to re-designate this computer as a LAN Workstation and point to the LAN server containing the shared H2OS database.


This option will release LAN connections and switch this computer from running H2OS as a LAN workstation to a standalone installation using the local (on this machine) H2OS database installation's files and not those on the LAN server.


For more information on the location of files involved, see the distribution of files topic



Fallback to last H2OS release


Renames current executable so it will not be located during startup, which will cause startup to run the immediately preceding release (assuming the previous release EXE still exists in the C:\H2OS folder).


For example, if you have these versions of H2OS installed:







The current executable (version) is LS051513.EXE, the highest number executable.


By renaming this executable, H2OS will find and launch the now highest version number, LS051512.EXE


The renamed executable will appear ls LX051513.EXE





H2OS Online Help





Launch your Internet browser to view the online copy of the H2OS Customer Guide


Restore a full H2OS created backup



Restore the H2OS database from an H2OS created backup.


H2OS backups are initially stored in the BACKUPS folder designated by setup->options->backups


Recover will ask you to point to the backup to be restored and the root folder to restore into.



Reset current database



If it appears that the problem is that H2OS cannot find or connect with the customers database table, you have 2 options using the Recovery Console.


Option 1:  Switch the current database table to a test (sample) database table (using this command) to start H2OS, then make changes to correct the problem and then switch the current database to your actual customers database table.


Clicking this command will switch the current Customers database to a sample database that was installed with H2OS, which should permit H2OS to start.  Once started, it may be possible to correct the problem and then use the FILE menu to select and open (connect) your actual  customers database table.


Option 2: use the "Change current database" command to use the Windows Navigator to point to the H2OS customers table to be used


Option 3: Restore an H2OS created backup


Option 4: Disconnect from LAN. If this computer is an H2OS LAN Workstation, this command will disconnect this computer from the designated server and to access the H2OS installation on this computer.





Restore default tab pages


Click to restore H2OS tab pages to a minimum set of tab pages.  


This option is provided in case it's obvious H2OS is failing to start due to a tab page problem. By changing the tab pages displayed to just a few basic pages this error can be bypassed to get H2OS started and to select tab pages to be displayed (excluding the failing page)



Restore default menu system



Restore the H2OS menu system to the default system (as shipped)


Turn off the H2OS automatic backup option



Turn off automatic backup


To eliminate the possibility that taking a backup during startup is causing or in some way exacerbating a problem.

Later, when H2OS starts, you can use setup->options->backup to turn this option back on.



Turn off TIPS at started


Stops tips from being automatically displayed during H2OS startup






Browse or edit a database table


Enter, select from the pulldown menu, or use the ellipsis (...) command to use the Windows navigator to point to the table (xxxx.dbf) to be browsed or edited




Use for





To view the table in edit mode, which allows you to make changes to the table






To view the table in read-only mode



Using the recovery console

If H2OS fails to start for any reason,  Click H2OS Recover shortcut on your desktop


The Recovery Console can be used to make changes to your H2OS database without H2OS running at the time. This makes certain types of changes possible that would not be permitted if H2OS is running.