fbpx

Urecognized Database Format- How To Resolve

Introduction 

This document will help you if an error message arises when you attempt to open your database saying ‘Unable To Login- Unrecognized Database Format’.

This error message will come up if the database was not saved properly the last time the program was closed. This can be caused by turning off the computer with the program open, or from closing the database while it is saving to the hard drive.

There is one possible solution to repair the database. If the database cannot be repaired, you will need to restore the database from a back-up. Below are the steps to repair the database.

Step 1: Find your database file. The default location for the database file is under C:/rhserver/realhnd and has the file extension of .mdb.

Step 2: Double-click on the database file to open it directly in Microsoft Access. You will most likely see the same error message upon opening.

Step 3: Once Access is open, go to Help/Detect and Repair. This will run a tool that will attempt to repair and open the database file. If the tool completes, make sure to go to File/Exit to properly close the program. You can then open the database in Realhound.

If the repair tool in Access cannot fix the database, you will need to restore from a back-up of your database to gain access again. For assistance in restoring from a database back-up, please visit our techdoc on restoring a back-up, linked below.

Tune-up for SQL Database

Introduction (Please Read) This document will help you perform a tune-up of your SQL database in addition to the Realhound tune-up. This SQL tune-up should be completed on a weekly basis to keep your database running at full speed. Steps: Step 1.Log out of your Realhound database and ensure that all other users are logged out of the database as well. It is imperitive that all users are logged out of the database before performing this tune-up. Failure to do so will cause irreversable damage to your database. Step 2. Go to the Realhound program folder on your machine housing the SQL database. The program folder will be located by default in C:/rhserver/realhnd. Inside this folder you will see the file ‘reindex.sql’. Double-click on this file to run the SQL tune-up. reindex.sql reindexsql The SQL reindex performs the following functions… 1. Performs its own reindex 2. Rebuilds the temporary fields within the database (many things are denormalized in the database for speed, such as related contact names on the task list, these are refreshed) 3. Fixes any invalid records in the database (these can occur if a program loses network connection during a read/write process) 4. Verifies all of the primary keys in each table 5. Deletes any orphan records that may not have been deleted through normal processes if SQL Server had them locked 6. Verifies the structure of the database against a current baseline (if we add fields, this is how they get added to the database)

SQL Database Grows Extremely Large

Introduction (Please Read): This document will walk you through the steps needed to turn off the transaction logs in SQL. These transaction logs can cause your SQL database to grow extremely large and take up valuable hard drive space. Running SQL in Full Recovery Mode allows for complete back-ups to be taken of a database during changes, although the transaction logs can become large enough to take up an entire hard drive if left on long enough. To Decrease the SQL database size and recover hard drive space. Step 1 – Set SQL to run in Simple Recovery Mode Step 2 – At the Realhound login screen, run a speed-up of the database to decrease database size dramatically.

SQL Remote Access Setup

Introduction (Please Read):
This document will walk you through the steps needed to access the program while in separate offices. Please note – A better plan is to install RH on the user’s laptop and use Live to connect to their database.

Step 1 – Open regedit from the registry
hkey_local_user\software\realhound.com\realhound key.

Step 2 – Look for the values are:

SQLServerDatabsae
SQLServerServer
SQLServerUser
SQLServerPassword

The best idea would be to have a .reg script saved from regedit with the keys you want, then this is run before logging into RH.

You will likely have speed issues though as you are no longer on the local LAN.

How to Sync Live SQL Server Database When Realhound is Not Running

How to Sync Live SQL Server Database When Realhound is Not Running

Introduction (Please Read): This document will provide you with the steps needed to sync a Live database when Realhound is not running (i.e. on a server). As with the rest of the SQL server setup process, this should only be attempted by someone with a strong IT background and SQL experience. Steps: /ss:10.20.6.138 /sd:realhound /sp:realhound /su:realhound /u:administrator /p:realhound /t:c:\rhtemp /h:365 /x Sync
Error Installing SQL Server Express 2005

Error Installing SQL Server Express 2005

Introduction (Please Read): This document will provide you with the steps necessary to completing the installation of SQL Server Express 2005. If the MSXML or any of the other components don’t install properly, then it is likely that you have a previous version of the component installed. SQL Install Steps: 1. Go to http://support.microsoft.com/kb/290301 and download the Windows Installer Cleanup Utility package. 2. Once the package downloads, double-click on it to install it. 3. Once the installation finishes, run the program (go to your Start Menu –> All Programs and select the utility). 4. In the window that opens, scroll through the list and identify any MSXML or SQL programs. For each one, select it in the list and click the Remove button. NOTE: Be cautious when removing any programs with this tool as you will be permanently removing programs from your computer. Do not attempt unless you understand what you are removing. 5. Once this has been done for each of the previously existing programs, close the Windows Install Cleanup Utility and go through the installation again.