RPS Toolkit Instructions

The purpose of this tool kit is to provide the customer with a utility that will allow them to compact and repair the MS Access remote programmer database, as well as some other functions.

Start the toolkit by double-clicking on RPSToolkit.exe:

To compact the RPS database (MS Access only):
•	Click the “Compact” button.
•	When the compact is finished, the bottom of the RPS Toolkit window will display “Compacting Database…Success” Or “Compacting Database…Failure”

In the event that the compact utility fails, please contact the technical support department.

To repair the RPS database (MS Access Only):
•	Click the “Repair” button.
•	When the compact is finished, the bottom of the RPS Toolkit window will display “Repairing Database…Success” Or “Repairing Database…Failure”

In the event that the repair utility fails, please contact the technical support department.

FAQ’s

When should the RPS Access database be compacted?
•	Compacting should be done anytime that performance of the remote programming application appears to be slower than normal 
•	This should also be done if several records in the database have been added or deleted. This includes Accounts in the Panel List, Templates, Operators, etc.

Why should the RPS Access database be compacted?
•	Compacting a database is similar to defragmenting a computer’s hard drive. If files are often added and deleted, this tends to leave gaps in the file structure, which causes data-lookups to take a longer than normal. Compacting the RPS database may prevent poor performance, if it is done often enough.

When and why should the Access database be repaired?
•	Occasionally, Access databases tend to become corrupt. This prevents the application from retrieving data from it and writing data to it. If accounts no longer open, there is a good chance that the database is corrupt and the database should be repaired to remedy the situation.

Merge Database Utility:

From the RPS Toolkit, click Tools >> Merge Database.

When the Merge Database Utility opens:

Merge from MS Access: 
1) Check the “Access database” box if you are currently using and MS Access database (ramivdta.mdb). Enter the location of the MS Access database to be merged. 

Merge from SQL:
1) Leave the box unchecked if you are using a SQL database and fill in the SQL server information as it pertains to the current SQL database.

2) Click on the Destination Database Details tab and enter the information for the database that you will be using from this point forward. 

3) When all of the details are filled in, click on Merge Database and a confirmation window will appear indicating the merge was successful. All of the account information from the Source database will be carried over to the Destination database.